Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-134

item-storage API - GET after doing POST from item-storage(4 concurrent users) by itemId takes ~7 seconds

    XMLWordPrintable

Details

    • Other dev

    Description

      Environment
      psql (PostgreSQL) 9.6.8

      folio=# select count(*) from supertenant_mod_inventory_storage.item;
      count
      ---------
      2908651
      (1 row)

      Steps to reproduce:
      Using Postman or JMeter, make an HTTP request call to mod-inventory-storage item-storage API
      1. GET /item-storage/items
      2. POST /item-storage/items
      Body Data:

      { "holdingsRecordId": "2b92dc88-d44d-4dc3-bd9e-89596adbe54b", "materialTypeId": "1a54b431-2e4f-452d-9cae-9cee66c9a892", "permanentLoanTypeId": "2b94c631-fca9-4892-a730-03ee529ffe27" }

      3. GET /item-storage/items/5ee11d91-f7e8-481d-b079-65d708582ccc
      4. PUT /item-storage/items/5ee11d91-f7e8-481d-b079-65d708582ccc

      { "id" : "1e399da3-782b-4312-9e3b-ef7ee2238a81", "holdingsRecordId": "d031681a-dbb9-49d0-9367-90419168d0c0", "pieceIdentifiers": ["This is test identifier"], "notes": ["This is test notes"], "materialTypeId": "1a54b431-2e4f-452d-9cae-9cee66c9a892", "permanentLoanTypeId": "2b94c631-fca9-4892-a730-03ee529ffe27" }

      5. GET /item-storage/items/5ee11d91-f7e8-481d-b079-65d708582ccc
      6. DELETE /item-storage/items/5ee11d91-f7e8-481d-b079-65d708582ccc
      7. GET /item-storage/items/5ee11d91-f7e8-481d-b079-65d708582ccc

      Observation:

      GET after POST takes following:
      1 User -> 24 ms
      2 Users -> 2805 ms
      3 Users -> 5334 ms
      4 Users -> 7072 ms

      Initially, response time increases exponentially and then it keeps increasing linearly. I have attached DEBUG logs from PostgreSQL and JMeter Summary logs for concurrent Users.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Umbrella - FOLIO-1711 Performance issues reported through the automatic perf testing Q1

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-124 material-type API - delete from material-type by materialTypeId sql query takes more than 5 seconds to execute

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

            New Feature - New feature requests MODINVSTOR-118 Use identity column for GET, PUT and DELETE implementations

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-146 Performance - POST and PUT for /inventory/items endpoint takes ~10 to ~15 seconds

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

            Task - A task that needs to be done. MODINVSTOR-237 Performance: GET 200 - Get updated mod-inventory/item by using modInventoryItemId

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                julianladisch Julian Ladisch
                varunjavalkar Varun Javalkar
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases