http://www.datastax.com/support-forums/topic/wide-row-column-slicing-row-size-shard-limit Software, Support, and Training for Apache Cassandra en-US Wed, 22 May 2013 17:33:51 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/wide-row-column-slicing-row-size-shard-limit#post-1112 Thu, 09 Feb 2012 18:40:28 +0000 Anonymous 1112@http://www.datastax.com/support-forums/ <p>Manually sharding the wide row will increase the application complexity, it would be better if Cassandra can handle it transparently.</p> <p>Thanks,<br /> Charlie | DBA &amp; Developer </p> http://www.datastax.com/support-forums/topic/wide-row-column-slicing-row-size-shard-limit#post-1105 Thu, 09 Feb 2012 01:10:38 +0000 Anonymous 1105@http://www.datastax.com/support-forums/ <p>Based on this blog of Basic Time Series with Cassandra data modeling,<br /> <a href="http://rubyscale.com/blog/2011/03/06/basic-time-series-with-cassandra/" rel="nofollow">http://rubyscale.com/blog/2011/03/06/basic-time-series-with-cassandra/</a></p> <p>"This (wide row column slicing) works well enough for a while, but over time, this row will get very large. If you are storing sensor data that updates hundreds of times per second, that row will quickly become gigantic and unusable. The answer to that is to shard the data up in some way"</p> <p>There is a limit on how big the row size can be before slowing down the update and query performance, that is 10MB or less.</p> <p>Is this still true in Cassandra latest version? or in what release Cassandra will remove this limit?</p> <p>Thanks,<br /> Charlie | DBA</p> <p>p.s. Quora link,<br /> <a href="http://www.quora.com/Cassandra-database/What-are-good-ways-to-design-data-model-in-Cassandra-for-historical-data" rel="nofollow">http://www.quora.com/Cassandra-database/What-are-good-ways-to-design-data-model-in-Cassandra-for-historical-data</a> </p>