On Mon, Jul 23, 2012 at 11:00 AM, Ertio Lew <ertio...@gmail.com> wrote:
> For each user in my application, I want to store a *value* that is queried > by using the userId. So there is going to be one column for each user > (userId as col Name & *value* as col Value). Now I want to store these > columns such that can efficiently read columns for atleast 300-500 users > in a single read query. Is the query timebased or userid based? How do you determine which users to read first? Do you read all of them or few of them? What's the query criteria? It would be helpful to understand exactly how your query works. In NoSQL there are no Btree indexes, which means you need to store data that is materialized based on your query pattern.
