Re: Prepare is 100 to 200 times slower after migration to 1.2.11

2013-11-27 Thread Shahryar Sedghi
Thanks Mikhail. I switched to 2.0.3 and the problem is still there, I will open an issue with a test case on it. I have not tested 1.2.12, but I assume that will have the same problem. Shahryar On Mon, Nov 25, 2013 at 5:57 PM, Shahryar Sedghi shsed...@gmail.com wrote: I did some test and

Prepare is 100 to 200 times slower after migration to 1.2.11

2013-11-25 Thread Shahryar Sedghi
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

Re: Prepare is 100 to 200 times slower after migration to 1.2.11

2013-11-25 Thread Shahryar Sedghi
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

Re: Prepare is 100 to 200 times slower after migration to 1.2.11

2013-11-25 Thread Mikhail Stepura
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