RE: Cassandra Data Model design

2014-10-06 Thread Rahul Gupta
You need rethink your data model for client_data table. Unlike RDBMS, Cassandra heavily relies on Primary Key for filtering data. In fact using any column other than primary key is not recommended when you are using Cassandra. This means that how you design your Primary Key is critical. There ar

Re: Cassandra Data Model design

2014-09-22 Thread James Briggs
, September 17, 2014 3:35 PM Subject: Re: Cassandra Data Model design It takes around more than 50 seconds to return back 500 records from cqlsh command not from the code so that's why I am saying it is pretty slow. On Wed, Sep 17, 2014 at 3:17 PM, Hao Cheng wrote: How slow is slow? Regardle

Re: Cassandra Data Model design

2014-09-17 Thread Check Peck
It takes around more than 50 seconds to return back 500 records from cqlsh command not from the code so that's why I am saying it is pretty slow. On Wed, Sep 17, 2014 at 3:17 PM, Hao Cheng wrote: > How slow is slow? Regardless of the data model question, in my experience > 500 rows of relatively

Re: Cassandra Data Model design

2014-09-17 Thread Hao Cheng
How slow is slow? Regardless of the data model question, in my experience 500 rows of relatively light content should be lightning fast. Looking at my performance results on a test cluster of 3x r3.large AWS instances, we reach an op rate on Cassandra's stress test of at least 1000 operations per s

Re: Cassandra Data Model Design Visualization

2010-06-29 Thread Peter Sankauskas
This sounds like an excellent reason to build a Cassandra Eclipse plugin - it doesn't look like anyone is doing this yet. Kind regards, Peter Sankauskas Motally, Inc Office: +1 (415) 932-6898 On Tue, Jun 29, 2010 at 8:59 AM, Utku Can Topçu wrote: > Hey Guys, > > I've been into designing an ap