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

    • Template:

      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

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases