Re: millions of columns in a row vs millions of rows with one column

2011-02-21 Thread Héctor Izquierdo Seliva
El mar, 22-02-2011 a las 08:49 +1300, Aaron Morton escribió: > 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

Re: millions of columns in a row vs millions of rows with one column

2011-02-21 Thread Aaron Morton
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 wrote: > Hi Everyone.

millions of columns in a row vs millions of rows with one column

2011-02-21 Thread Héctor Izquierdo Seliva
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?