Re: Best practices for frequently updated columns

2014-08-15 Thread Philo Yang
The write performance of INSERT or UPDATE is very high in C*, but if you update too often the row you update frequently will be in many SSTables so the read latency and system load will be increased until these SSTables are compacted into one single file. I think you can use redis (or memcache)

Best practices for frequently updated columns

2014-08-13 Thread Jeremy Jongsma
We are building a historical timeseries database for stocks and futures, with trade prices aggregated into daily bars (open, high, low, close values for the day). The latest bar for each instrument needs to be updated as new trades arrive on the realtime data feeds. Depending on the trading volume

Re: Best practices for frequently updated columns

2014-08-13 Thread Robert Coli
On Wed, Aug 13, 2014 at 8:01 AM, Jeremy Jongsma jer...@barchart.com wrote: I've read comments about frequent column updates causing compaction issues with Cassandra. What is the recommended Cassandra configuration / best practices for usage scenarios like this? If your data is frequently