[ https://issues.apache.org/jira/browse/CASSANDRA-18104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17646129#comment-17646129 ]
Sreedhar J commented on CASSANDRA-18104: ---------------------------------------- Thanks [~brandon.williams] for the updates. We still see slowness of 4.0.x compare to 3.11.x reran the test but with TRACING ON. summed up the microseconds reported as "Request Complete" for each run. 3.11.14: Sum of request complete source_elapsed converted to seconds: 0.551421 Results from "time" command: real 0m6.709suser 0m5.177ssys 0m0.157s 4.0.7: Sum of request complete source_elapsed converted to seconds: 0.869646 Results from "time" command: real 0m6.914suser 0m4.981ssys 0m0.128s So the tracing says all my queries took less than a second. But still higher on 4.0.7. using time is not the best way to measure this. time would include all of the python overhead in addition to the query time. > Major Performance degradation of Casandara 4.0.7 against Casandra 3.11.14 > ---------------------------------------------------------------------------- > > Key: CASSANDRA-18104 > URL: https://issues.apache.org/jira/browse/CASSANDRA-18104 > Project: Cassandra > Issue Type: Bug > Reporter: Sreedhar J > Priority: Urgent > Attachments: 3.11.14.txt, 4.0.7.txt, mailboxes_snapshot.zip, > query30.txt > > > Our application uses Casandra 3.11.x and has lot of security vulnerabilities > which are addressed in 4.0.x. So we have upgraded the Casandra to 4.0.7 > and our performance tests have shown aorund 20% degradation compare to > 3.11.x > We are now able to reproduce the same performance degradation using the > standalone queries. Here are the steps. > 1. Expand Cassandra 3.11.14 tarball and 4.0.7 tarball to different folders > 2. Import the attached data from the snapshot (mailboxes_snapshot.zip) into > each Cassandra instance, see schema.cql for CQL for creating the required > table and indexes before import > 3. With CQLSH run the following query several times with TRACING ON and > PAGING OFF against both versions of Cassandra: select * from > mailbox.mailboxes where mbx_id= 6c57da2e-7ddd-4984-be62-105415e6b48a; > 4. Compare results > IWe ran the target query 30 times. Here's the average times to run the query: > 3.11.14 - 19400.77 > 4.0.7 - 34906.03 -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org