http://www.datastax.com/support-forums/topic/cassandra-performance-split-or-not-to-split-cf Software, Support, and Training for Apache Cassandra en-US Fri, 24 May 2013 10:20:20 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cassandra-performance-split-or-not-to-split-cf#post-9139 Fri, 22 Feb 2013 19:35:04 +0000 arviarya 9139@http://www.datastax.com/support-forums/ <p>You can split a column family on requirement basis. It depends how you are organizing your data or fetch. Generally, huge columns columns families may throw lots of data in your program that you may not need.<br /> Better organise your data in single and multiple CFs as per requirement. There are advantage of split CFs if you do not need to read both/all CFs for fetch.<br /> Writes are faster, hence you can send few duplicate data in both CFs to avoid joins. </p> http://www.datastax.com/support-forums/topic/cassandra-performance-split-or-not-to-split-cf#post-8849 Fri, 01 Feb 2013 16:40:07 +0000 Janbalik 8849@http://www.datastax.com/support-forums/ <p>Hi @ll,</p> <p>I'm working on the design of a Cassandra database to learn about it. But I have a question I would like some expert help me to clarify:</p> <p>I have read that the rows of each column family are distributed through the nodes, thus each node has a part of the rows of a given column family. Does it mean that it is not a good idea to divide a column family into many column families even when that column family has millions of rows?</p> <p>My experience with RDBMS says that is better to split very big tables into smaller tables to get a better performance, but it seems that in Cassandra there is no need of this and, even more, if I have many column families I would need more memory. Am I right? Is it better keeping many rows in a column family to get a better performance than split the column family in many?</p> <p>Thanks! </p>