Re: What's the best modeling approach for ordering events by date?

2011-04-15 Thread Ethan Rowe
Hi. So, the OPP will direct all activity for a range of keys to a particular node (or set of nodes, in accordance with your replication factor). Depending on the volume of writes, this could be fine. Depending on the distribution of key values you write at any given time, it can also be fine. B

Re: What's the best modeling approach for ordering events by date?

2011-04-14 Thread Guillermo Winkler
Hi Ethan, I want to present the events ordered by time, always in pages of 20/40 events. If the events are tweets, you can have 1000 tweets from the same second or you can have 30 tweets in a 10 minute range. But I always wanna be able to page through the results in an orderly fashion. I think th

Re: What's the best modeling approach for ordering events by date?

2011-04-14 Thread Ethan Rowe
How do you plan to read the data? Entire histories, or in relatively confined slices of time? Do the events have any attributes by which you might segregate them, apart from time? If you can divide time into a fixed series of intervals, you can insert members of a given interval as columns (or s

What's the best modeling approach for ordering events by date?

2011-04-14 Thread Guillermo Winkler
I have a huge number of events I need to consume later, ordered by the date the event occured. My first approach to this problem was to use seconds since epoch as row key, and event ids as column names (empty value), this way: EventsByDate : { SecondsSinceEpoch: { evid:"", evid:"", ev