cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Holstad <>
Subject ColumnFamilies vs composite rows in one table.
Date Fri, 05 Mar 2010 18:04:44 GMT
What are the benefits of using multiple ColumnFamilies compared to using a
row name?

Example: You have messages that you want to index on sent and to.

So you can either have

or something like
ColumnFamily:user_to:{user1_messageId, user2_messageId}
ColumnFamily:user_from:{user1_messageId, user2_messageId}

One thing that I can see the advantage of using families are if you want to
use different types in the families. But are there others? Like storage
read/write speeds etc.

Regards Erik

View raw message