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

            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