Thanks Aaron.. I was looking to spliting the rows so that I could use a standard CF instead of super.. but your argument also makes sense.
On Thu, Feb 24, 2011 at 1:19 AM, Aaron Morton <aa...@thelastpickle.com> wrote: > AFAIK performance in the single row case will better. Multi get may require > multiple seeks and reads in an sstable,, verses obviously a single seek and > read for a single row. Multiplied by the number of sstables that contain row > data. > > Using the key cache would reduce the the seeks. > > If it makes sense in your app do it. In general though try to model data so a > single row read gets what you need. > > Aaron > > On 24/02/2011, at 5:59 AM, Aditya Narayan <ady...@gmail.com> wrote: > >> Does it make any difference if I split a row, that needs to be >> accessed together, into two or three rows and then read those multiple >> rows ?? >> (Assume the keys of all the three rows are known to me programatically >> since I split columns by certain categories). >> Would the performance be any better if all the three were just a single row >> ?? >> >> I guess the performance should be same in both cases, the columns >> remain the same in quantity & there spread into several SST files.. >