Uploaded image for project: 'mod-circulation'
  1. mod-circulation
  2. CIRC-250

Remove unnecessary heavy count(*) query to item/holding/instance tables

    XMLWordPrintable

Details

    • Core: Platform - Sprint 59
    • 2
    • Core: Platform

    Description

      During checkin/out performance test, it was noticed that the module makes lots of strange and heavey queries. See below for example. Investigate and eliminate those.

      API calls
GET http://172.31.19.164:9130/item-storage/items?limit=0&offset=0
GET http://172.31.19.164:9130/holdings-storage/holdings?limit=0&offset=0
GET http://172.31.19.164:9130/instance-storage/instances?limit=0&offset=0
SQLs generated:
LOG:  duration: 176.296 ms  statement: SELECT COUNT(*) FROM supertenant_mod_inventory_storage.item
LOG:  duration: 175.530 ms  statement: SELECT COUNT(*) FROM supertenant_mod_inventory_storage.holdings_record
LOG:  duration: 166.366 ms  statement: SELECT COUNT(*) FROM supertenant_mod_inventory_storage.instance

      TestRail: Results

        Attachments

          Issue Links

            relates to

            Task - A task that needs to be done. FOLIO-1815 SPIKE: "profile" checkin/out-by-barcode API response time

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. FOLIO-1868 Analyze module calls generated from check-out-by-barcode request

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                hji Hongwei Ji
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases