Greetings!
Thank you very much sharing your insight and experience.
I am trying to migrate a normalized Schema -- 1 TB database. The data
is hierarchical...
child entities carry foreign keys to the parent entities. There are
several instances like
ShapeTable, Circle, Square, Rectangle
, February 26, 2013 12:27 AM
To: user@cassandra.apache.orgmailto:user@cassandra.apache.org
user@cassandra.apache.orgmailto:user@cassandra.apache.org
Subject: Re: Data Model - Additional Column Families or one CF?
Aaron,
Would 50 CFs be pushing it? According to
http://www.datastax.com/dev/blog/whats
@cassandra.apache.orgmailto:user@cassandra.apache.org
user@cassandra.apache.orgmailto:user@cassandra.apache.org
Subject: Re: Data Model - Additional Column Families or one CF?
Aaron,
Would 50 CFs be pushing it? According to
http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-improved-memory
@cassandra.apache.org
user@cassandra.apache.orgmailto:user@cassandra.apache.org
Date: Tuesday, February 26, 2013 12:27 AM
To: user@cassandra.apache.orgmailto:user@cassandra.apache.org
user@cassandra.apache.orgmailto:user@cassandra.apache.org
Subject: Re: Data Model - Additional Column Families or one CF
@cassandra.apache.orgmailto:user@cassandra.apache.org
user@cassandra.apache.orgmailto:user@cassandra.apache.org
Subject: Re: Data Model - Additional Column Families or one CF?
Aaron,
Would 50 CFs be pushing it? According to
http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-improved-memory
Aaron,
Would 50 CFs be pushing it? According to
http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-0-improved-memory-and-disk-space-management,
This has been tested to work across hundreds or even thousands of
ColumnFamilies.
What is the bottleneck, IO?
Thanks,
Javier
On Sun, Feb 24,
Thanks Aaron, this was a big help!
—
Sent from Mailbox for iPhone
On Thu, Feb 21, 2013 at 9:27 AM, aaron morton aa...@thelastpickle.com
wrote:
If you have a limited / known number (say 30) of types, I would create a
CF for each of them.
If the number of types is unknown or very large I
My data needs only require me to store JSON, and I can handle this in 1
column family by prefixing row keys with a type, for example:
comments:{message_id}
Where comments: represents the prefix and {message_id} represents some row
key to a message object in the same column family.
In this case