Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of asdkl93@gmail.com designates
 209.85.220.172 as permitted sender)
MIME-Version: 1.0
Date: Fri, 27 Jul 2012 11:12:38 +0530
Message-ID: 
 <CAEqOBHP=mobvwGgu1erPgswwX9v4N3=to=T3YEWUxtdTvaQnEQ@mail.gmail.com>
Subject: Schema question : Query to support "Find which all of these 500 email
 ids have been registered"
From: Aklin_81 <asdkl93@gmail.com>
To: user <user@cassandra.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

I need to find out what all email ids among a list of 500 ids passed
in a single query, have been registered on my app. (Total registered
email ids may be in millions). What is the best way to store this kind
of data?

Should I store each email id in a separate row ? But then I would have
to read 500 rows at a single time ! Or if I use single row or less no
of rows then they would get too heavy.

Btw Would it be really bad if I read 500 rows at a single time,
they'll be just 1 column rows & never modified once written columns.