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

SPIKE: propose improvements to the hit count estimation function

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: Roadmap backlog
    • Development Team:
      Core: Platform

      Description

      A couple issues has been raised about the quality of the estimates:

      • estimate is way off for some queries
      • estimate differs depending on the type of query (e.g source=marc vs source==marc)
      • estimate is off when offset is higher than the estimation cutoff point (e.g offset=1500 and totalCount=1000)
      • estimate often higher than actual hitcount (trueCount=7891 vs hitCount=1000) see UIIN-1050

      Goal

      • once Postgres acccess to the Bugfest environment has been granted, review a sample of front-end queries (Charlotte Whitt should be able to help to provide them, based on the tickets in the result-count label) where estimation seems to be off and collect precise hitcount from the DB (COUNT(*)) to compare
        Please experiment with the /instance-storage/instances?query= endpoint to verify the behavior of the estimation. The CQL queries should be collected from the UIIN tickets linked to MODINVSTOR-468.

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                mikhail.fokanov Mikhail Fokanov
                Reporter:
                jakub Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases