Re: Optimal Way to Tune For Searchs For Missing Keys

2014-01-10 Thread Edward Capriolo
Cassandra great database for searching things that dont exist! How often do you get to say that? On Friday, January 10, 2014, Charlie Mason wrote: > Hi Rob, > It sounds like Cassandra is actually a very good fit with this use case. I have been experiencing slower performance in my app than I was

Re: Optimal Way to Tune For Searchs For Missing Keys

2014-01-10 Thread Charlie Mason
Hi Rob, It sounds like Cassandra is actually a very good fit with this use case. I have been experiencing slower performance in my app than I was expecting. Although I am fairly sure now its something else now rather than this part of the app. It was just with such a lot of queries I was keen to k

Re: Optimal Way to Tune For Searchs For Missing Keys

2014-01-09 Thread Robert Coli
On Thu, Jan 9, 2014 at 1:42 PM, Charlie Mason wrote: > There are a lot more reads than writes on this particular table. All of > the queries are just for the partition key. Most of the queries are for > partition keys that don't exists, more than 99% of the queries. > Reads for partition keys th

Optimal Way to Tune For Searchs For Missing Keys

2014-01-09 Thread Charlie Mason
Hi All, Does anyone have any suggestions about how to improve performance in the below use case? I have a very simple table with a single Partition Key, and one Cluster key. My app is periodically writing new entries in the table and deleting old ones. There are a lot more reads than writes on t