incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Single Column vs Multiple Columns
Date Fri, 17 Dec 2010 17:24:00 GMT
The performance difference is negligible and the other drawbacks are
significant, e.g., losing the ability to create indexes on a column.

On Fri, Dec 17, 2010 at 11:49 AM, Ericson, Doug
<doug.ericson@zoominfo.com>wrote:

>  I have a data model where each read and each write will read and write
> all data for a given key.  Thus, does it make more sense to separate the
> data into multiple columns, or does it make more sense to store all data in
> a single column?
>
>
>
> My understanding is that breaking data into multiple columns is an
> optimization for reading and writing a single column. If all data is updated
> for every write, and read for every read, then having all data in a single
> column offers better performance, is this a correct assumption?
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com

Mime
View raw message