My preference is to go with more rows as it distributes load better. But the best design is the one that supports your read patterns.
See http://wiki.apache.org/cassandra/LargeDataSetConsiderations for background. Aaron On 22/02/2011, at 3:56 AM, Héctor Izquierdo Seliva <[email protected]> wrote: > Hi Everyone. > > I'm testing performance differences of millions of columns in a row vs > millions of rows. So far it seems wide rows perform better in terms of > reads, but there can be potentially hundreds of millions of columns in a > row. Is this going to be a problem? Should I go with individual rows? I > run 6 nodes with 7.2 and a RF=3. > > Thanks for your help! >
