Merging 3 rows that are mostly read together from CF into single rows with composite col names ?

[Asil Klin <as...@gmail.com>]

If 3 rows in a column family need to be read together 'always', is it
preferable to just merge them in 1 row using composite col names(instead of
keeping in 3 rows) ? Does this improve read performance, anyway ?

Re: Merging 3 rows that are mostly read together from CF into single rows with composite col names ?

[Edward Capriolo <ed...@gmail.com>]

On Monday, December 26, 2011, Asil Klin <as...@gmail.com> wrote:
> If 3 rows in a column family need to be read together 'always', is it
preferable to just merge them in 1 row using composite col names(instead of
keeping in 3 rows) ? Does this improve read performance, anyway ?

You almost definitely want to merge this row. In spinning disk systems like
SCSI or sata seeking data on disk is at a premium so having 3 independent
seeks for data that is always read together is not good.