Re: Modeling transactional messages

2016-03-04 Thread Bryan Cheng
Cassandra? > > Thanks > > -- > IPVP > > > From: sean_r_dur...@homedepot.com > > Reply: user@cassandra.apache.org > > > Date: March 4, 2016 at 11:48:56 AM > To: user@cassandra.apache.org > > > Subject: RE: Modeling transactional messages > >

RE: Modeling transactional messages

2016-03-04 Thread I PVP
com> Reply: user@cassandra.apache.org ><mailto:user@cassandra.apache.org> Date: March 4, 2016 at 11:48:56 AM To: user@cassandra.apache.org ><mailto:user@cassandra.apache.org> Subject: RE: Modeling transactional messages As you have it, this is not a good model for Cassandra

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 create