Re: Data Modelling Help

2015-05-04 Thread Paulo Motta
This article explains when it's OK to use secondary indexes in Cassandra: http://www.wentnet.com/blog/?p=77 PS: the article is from 2013, so it can be outdated by now.. but at least it should give you some preliminary background on the topic. 2015-04-29 16:44 GMT-03:00 Robert Coli : > On Wed, Ap

Re: Data Modelling Help

2015-04-29 Thread Robert Coli
On Wed, Apr 29, 2015 at 9:01 AM, Donald Smith < donald.sm...@audiencescience.com> wrote: > Secondary indicies are inefficient and are deprecated, as far as I know. > They are not deprecated, the correct summary is that they should only be used in very particular circumstances. If you're not sure

RE: Data Modelling Help

2015-04-29 Thread Donald Smith
Secondary indicies are inefficient and are deprecated, as far as I know. Unless you store many thousands of emails for a long time (which I recommend against), just use a single table with the partition key being the userid and the timestamp being the clustering (column) key, as in your schema.