Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-613

optimizedSql performance regression

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: sprint 88
    • Development Team:
      Core: Platform

      Description

      CQL: contributors = "American Bar Association" sortBy title
      URI: /instance-storage/instances?limit=30&query=contributors%20%3d%20%22American%20Bar%20Association%22%20sortBy%20title

      Running this query against the performance test dataset takes

      • 0.4 s when mod-inventory-storage uses RMB 29.4.0 and
      • 4.8 s when mod-inventory-storage uses 29.5.0-SNAPSHOT

      This performance regression is also reported by the daily folio-perf-platform report. The performance tests use more complicated queries, I reported a simplified query in this Jira. Look at the max value because this regression affects queries with a bigger hit count (like Aerican Bar Association with hit count 1281) and only a few queries have a bigger hit count:

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                mikhail.fokanov Mikhail Fokanov
                Reporter:
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases