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..