Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-16078

Performance regression for queries accessing multiple rows

    XMLWordPrintableJSON

    Details

    • Bug Category:
      Degradation - Performance Bug/Regression
    • Severity:
      Critical
    • Complexity:
      Normal
    • Discovered By:
      Performance Regression Test
    • Platform:
      All
    • Impacts:
      None

      Description

      This is spin off from CASSANDRA-16036.

      In testing 4.0 relative to 3.0* I found that queries which accessed multiple rows to have a noticeable performance decrease; two queries were used in the test (more may be impacted, others might not): query partition (table has clustering keys) with LIMIT, and query clustering keys using IN clause.

      In the below graphs the green line is 3.0 and the other lines are 4.0 (with and without chunk cache)

      Partition with LIMIT


      Cluster with IN clause


        Attachments

        1. image.png
          99 kB
          Ekaterina Dimitrova

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                dcapwell David Capwell
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: