http://www.datastax.com/support-forums/topic/write-fast-read-verryverry-slow Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 07:56:18 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/write-fast-read-verryverry-slow#post-1097 Wed, 08 Feb 2012 18:17:40 +0000 Anonymous 1097@http://www.datastax.com/support-forums/ <p>Hey,</p> <p>I hope you can help me.</p> <p>My Setup:<br /> I have a cassandra setup with two nodes. On this I actually have one Keyspace with the replication factor 2 and one Column Family.<br /> This column family contains &lt;2.000 rows and each row has round about 200 Collumns (growing).</p> <p>Inserting data is fine. Verry fast, verry coool!</p> <p>Now my problem:<br /> I'm trying to sth. like a scan over all collumns of one row. Therefor I use Java Hector and coded the following</p> <p>...<br /> SliceQuery&lt;String,UUID,byte[]&gt; query = HFactory.createSliceQuery("myKeyspace", StringSerializer.get(), TimeUUIDSerializer.get(), BytesArraySerializer.get());<br /> query.setColumnFamily("myCf").setKey("someKey").setRange(null, null, false, 10000);<br /> QueryResult&lt;ColumnSlice&lt;UUID, byte[]&gt;&gt; result = query.execute();</p> <p>List&lt;HColumn&lt;UUID, byte[]&gt;&gt; columns = result.get().getColumns();<br /> ...</p> <p>It seems that the query.execute() command takes several seconds to return (~10). This seems to be very slow for me. And it seems that the number of Collums is not the cause of this.</p> <p>Does anyone has a hint for me?</p> <p>Kind regards<br /> spoi </p>