It can be https://issues.apache.org/jira/browse/CASSANDRA-6369 fixed in 1.2.12/2.0.3
-M "Shahryar Sedghi" <shsed...@gmail.com> wrote in message news:cajuqix7_jvwbj7sx5p8hvmwy5od5ze7pbtv1y5ttga2aws6...@mail.gmail.com... 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? Thanks On Mon, Nov 25, 2013 at 1:02 PM, Shahryar Sedghi <shsed...@gmail.com> wrote: Hi 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. Thanks Shahryar -- -- 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
