incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikhail Stepura" <>
Subject Re: Prepare is 100 to 200 times slower after migration to 1.2.11
Date Tue, 26 Nov 2013 05:02:57 GMT
It can be fixed in 1.2.12/2.0.3


"Shahryar Sedghi" <> wrote in message
I did some test and apparently the prepared statement is not cached at all, in a loop (native
protocol, datastax java driver, both 1.3 and 4.0)  I prepared the same statement  20 times
and the elapsed time where almost identical. I think it has something to do with CASSANDRA-6107
that was implemented in 1.2.11 and 2.0.2, I did the same test with 2.0.2 and got the same
result. is there a setting for CQL3 prepared cahe that I have missed in 1.2.11?


On Mon, Nov 25, 2013 at 1:02 PM, Shahryar Sedghi <> wrote:


  I have migrated my DEV environment from 1.2.8 to 1.2.11 to finally move to 2.0.2,  and prepare
is 100 to 200 times slower, something that was sub millisecond  now is 150 ms. Other CQL operations
are normal.

  I am nor planning to move to 2,0.2 until I fix this. I do  not see any warn or error in
the log, the only thing I saw was live ratio around 6.

  Please help.





Life has no meaning a priori … It is up to you to give it a meaning, and value is nothing
but the meaning that you choose ~ Jean-Paul Sartre
View raw message