Hello Kevin You'll be probably interested by this : http://www.datastax.com/dev/blog/row-caching-in-cassandra-2-1
On Sun, Jun 1, 2014 at 9:49 PM, Kevin Burton <bur...@spinn3r.com> wrote: > It's possible to set caching to: > > all, keys_only, rows_only, or none > > .. for a given table. > > But we have one table which is MASSIVE and we only need the most recent > 4-8 hours in memory. > > Anything older than that can go to disk as the queries there are very rare. > > … but I don't think cassandra can do this (which is a shame). > > Another option is to partition our tables per hour… then tell the older > tables to cache 'none'… > > I hate this option though. A smarter mechanism would be to have a > compaction strategy that created an SSTable for every hour and then had > custom caching settings for that table. > > The additional upside for this is that TTLs would just drop the older data > in the compactor.. > > -- > > Founder/CEO Spinn3r.com > Location: *San Francisco, CA* > Skype: *burtonator* > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > <https://plus.google.com/102718274791889610666/posts> > <http://spinn3r.com> > War is peace. Freedom is slavery. Ignorance is strength. Corporations are > people. > >
