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

    • CP: Roadmap backlog
    • 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 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

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases