Re: Modeling transactional messages

2016-03-04 Thread Bryan Cheng
e: March 4, 2016 at 11:48:56 AM > To: user@cassandra.apache.org <user@cassandra.apache.org>> > <user@cassandra.apache.org> > Subject: RE: Modeling transactional messages > > As you have it, this is not a good model for Cassandra. Your partition key > has only 2 speci

RE: Modeling transactional messages

2016-03-04 Thread I PVP
com><mailto:sean_r_dur...@homedepot.com> Reply: user@cassandra.apache.org <user@cassandra.apache.org>><mailto:user@cassandra.apache.org> Date: March 4, 2016 at 11:48:56 AM To: user@cassandra.apache.org <user@cassandra.apache.org>><mailto:user@cassandra.apache.org> Sub

RE: Modeling transactional messages

2016-03-04 Thread SEAN_R_DURITY
As you have it, this is not a good model for Cassandra. Your partition key has only 2 specific values. You would end up with only 2 partitions (perhaps owned by just 2 nodes) that would quickly get huge (and slow). Also, secondary indexes are generally a bad idea. You would either want to