Okay so as most know this practice is called a wide row - we use them quite a lot. However, as your schema shows it will cache (while being active) all the row in memory. One way we got around this issue was to basically create some materialized views of any more common data so we can easily get to the minimum amount of information required without blowing too much memory with the larger representations.
My perspective is that indexing some of the higher levels of data would be the way to go - Solr or elastic search for distributed or if you know you only need it local just use a caching solution like ehcache. Anthony On 28/10/2011, at 21:42 PM, Aditya Narayan wrote: > I need to keep the data of some entities in a single CF but split in two rows > for each entity. One row contains an overview information for the entity & > another row contains detailed information about entity. I am wanting to keep > both rows in single CF so they may be retrieved in a single query when > required together. > > Now the problem I am facing is that I want to cache only first type of > rows(ie, the overview containing rows) & avoid second type rows(that contains > large data) from getting into cache. > > Is there a way I can manipulate such filtering of cache entering rows from a > single CF? > >
