PTF - Pick slip limit performance testing

PTF - Pick slip limit performance testing

Overview

Defined SLAs:

  • Performance: Response times for the Print Pick Slip API are expected to remain within a range of seconds.

  • Functionality: The API must correctly enforce the configured 2,500 pick slip limit per request.

  • Reliability: 0% error rate during the full test duration.

  • Resource Stability: No memory leaks; Memory utilization should decrease after test completion.

Summary

  • The Print Pick Slip API was tested with 10 concurrent users over a 30-minute duration.

  • Both test runs completed successfully with no errors.

  • The API correctly enforces the configured limit and returns 2,500 slips as expected.

  • Test 1 processed 14,132 requests with an average response time of 1.3 sec; Test 2 processed 11,894 requests with an average response time of 1.5 sec.

  • mod-circulation Service Memory utilization peaked at ~50% (approximately 1300–1440 MB) during the tests and gradually decreased after test completion with no memory leaks observed.

Service Level Agreement (SLA) Compliance

Criteria

Status

Criteria

Status

Response Time

✅ Met

Pick Slip Limit Enforcement

✅ Met

Error Rate

✅ Met

Memory Stability (No Leaks)

✅ Met

 

Test Runs 

Test

Test description

Status

Test 1-2

Invoke the Print Pick Slip API with 10 concurrent users continuously for 30 minutes

Completed 

Results

This table contains Response Times:

 

Test 1

Test 2

API call

Samples

Average

pct90

Samples

Average

pct90

GET_circulation/pick-slips/{servicePointId}

14132

1,3 sec

1,6 sec

11894

1,5 sec

1,8 sec


The API correctly enforces the 2,500 pick slip limit and returns the expected result:

image-20260518-141859.png

 

Resources Utilization

Service Memory Utilization

mod-circulation memory usage was ~25% before test (slightly lower in Test 2) and averaged ~50% during both tests.

Test 1

image-20260518-120022.png

Test 2

image-20260518-120816.png

 

Service CPU Utilization

mod-circulation is the dominant consumer ~1,686–1,747% across both tests (percentage corresponds to the 64 CPU units allocated to the service).

Test 1

image-20260518-121220.png

Test 2 

image-20260518-121451.png

DB CPU Utilization

DB CPU utilization remained stable at ~42–50% across both tests. In Test 1, a background job (delete_old_marc_indexers_versions) introduced additional load (up to 65%) toward the end but did not affect response times.

Test 1

image-20260518-121805.png

Test 2

image-20260518-121846.png

 

DB load

Test 1

image-20260518-135302.png
image-20260519-073327.png

 

Test 2 

image-20260519-073648.png
image-20260519-073456.png

 

Appendix

Infrastructure

PTF -environment SELCTLS2 (tenant - cs00000int_0004, servicePointId - a51ec277-5a45-471b-9306-3c88afc003d9)

  • 8 r7i.2xlarge EC2 instances located in US East (N. Virginia)us-east-1

  • db.r7g.xlarge database instance, writer

  • MSK - ptf-loc-1

    • 6 kafka.m7g.xlarge brokers in 2 zones (3 per zone)

    • Apache Kafka version 3.9.x

    • EBS storage volume per broker 300 GiB

    • auto.create.topics.enable=true

    • log.retention.minutes=480

    • default.replication.factor=2

  • Open Search ptf-loc:

    • Data node - r7g.2xlarge.search (4)

    • Master node - m7g.large.search (3)

 

Module Task Definition Revision Module Version Task Count Mem Hard Limit Mem Soft Limit CPU Units Xmx Metaspace Size Max Metaspace Size mod-remote-storage 21 mod-remote-storage:3.4.3 2 4920 4472 64 3960 512 512 mod-remote-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-finance-storage 24 mod-finance-storage:8.8.8 2 1024 896 64 700 88 128 mod-finance-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-mosaic 11 mod-mosaic:1.0.0 2 1024 896 64 768 88 128 mod-mosaic - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-ebsconet 10 mod-ebsconet:2.4.0 2 1248 1024 64 700 128 256 mod-ebsconet - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-sip2 10 edge-sip2:3.4.3.tls 2 1024 896 64 768 88 128 mod-consortia-keycloak 17 mod-consortia-keycloak:1.7.3.tls 2 5136 4776 512 4416 384 512 mod-consortia-keycloak - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-tags 15 mod-tags:2.4.1 2 1024 896 64 768 88 128 mod-tags - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-notify 15 mod-notify:3.4.1 2 1024 896 64 768 88 128 mod-notify - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-inventory-update 10 mod-inventory-update:4.1.0 2 1024 896 64 768 88 128 mod-inventory-update - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-configuration 15 mod-configuration:5.12.1 2 1024 896 64 768 88 128 mod-configuration - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-caiasoft 20 edge-caiasoft:2.4.1.tls 2 1024 896 64 768 88 128 folio-keycloak 16 folio-keycloak:26.5.2.tls 3 2750 2250 1536 1536 0 0 mod-gobi 10 mod-gobi:3.0.2 2 1024 896 64 768 88 128 mod-gobi - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-licenses 16 mod-licenses:6.2.5 2 2480 2312 64 1792 384 512 mod-licenses - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-graphql 11 mod-graphql:1.13.1 2 1024 896 64 768 88 128 mod-graphql - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-erm-usage 14 mod-erm-usage:5.1.1 2 2800 2550 64 1800 384 512 mod-erm-usage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-roles-keycloak 16 mod-roles-keycloak:3.0.15.tls 4 4096 3688 128 3076 88 256 mod-roles-keycloak - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-batch-print 15 mod-batch-print:1.3.0 2 1024 896 64 768 88 128 mod-batch-print - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-copycat 15 mod-copycat:1.8.1 2 1024 896 64 768 88 128 mod-copycat - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-entities-links 19 mod-entities-links:4.0.3 2 2592 2483 64 1440 0 1024 mod-entities-links - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 pub-edge 5 pub-edge:2025.09.19 2 1024 896 64 768 0 0 mod-orders 20 mod-orders:13.0.10 2 2048 1740 64 1024 384 512 mod-orders - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 kong 13 kong:3.9.2 2 6144 6144 64 768 88 128 edge-patron 9 edge-patron:5.3.3.tls 2 1024 896 64 768 88 128 edge-ncip 8 edge-ncip:1.10.3.tls 2 1024 896 64 768 88 128 mod-users-bl 10 mod-users-bl:7.10.4 2 1440 1152 64 922 88 128 mod-users-bl - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-inventory-storage 24 mod-inventory-storage:29.0.19 2 4096 3690 512 3067 384 512 mod-inventory-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 768 512 256 0 128 mod-invoice 19 mod-invoice:6.0.4 2 1440 1152 64 922 88 128 mod-invoice - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-sender 10 mod-sender:1.14.2 2 1024 896 64 768 88 128 mod-sender - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-login-keycloak 15 mod-login-keycloak:3.0.4.tls 2 1024 896 128 512 88 256 mod-login-keycloak - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mgr-tenant-entitlements 14 mgr-tenant-entitlements:3.1.10.tls 2 1024 896 64 512 88 256 mod-data-export-worker 16 mod-data-export-worker:3.4.14 2 3072 2800 64 2048 384 512 mod-data-export-worker - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 768 64 256 0 128 mod-circulation-storage 20 mod-circulation-storage:17.4.3 2 2880 2592 64 1814 384 512 mod-circulation-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-calendar 15 mod-calendar:3.3.1 2 2048 1536 64 1024 96 256 mod-calendar - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-event-config 15 mod-event-config:2.9.1 2 1024 896 64 768 88 128 mod-event-config - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-courses 15 mod-courses:1.4.13 2 1024 896 64 768 88 128 mod-courses - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-circulation-item 17 mod-circulation-item:1.2.2 2 1024 896 64 0 0 0 mod-circulation-item - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-email 15 mod-email:1.19.1 2 2800 2550 64 1800 384 512 mod-email - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-di-converter-storage 17 mod-di-converter-storage:2.4.3 2 1024 896 64 768 88 128 mod-di-converter-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-circulation 16 mod-circulation:24.4.20 2 2880 2592 64 1814 384 512 mod-circulation - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-pubsub 15 mod-pubsub:2.16.3 2 1536 1440 1024 922 384 512 mod-pubsub - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 512 256 0 96 edge-rtac 20 edge-rtac:2.9.4.tls 2 1024 896 64 768 88 128 edge-orders 11 edge-orders:3.2.3.tls 2 1024 896 64 768 88 128 mod-users 21 mod-users:19.5.4 2 1024 896 64 768 88 128 mod-users - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-template-engine 15 mod-template-engine:1.22.2 2 1024 896 64 768 88 128 mod-template-engine - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-audit 15 mod-audit:2.11.5 2 1024 896 64 768 88 128 mod-audit - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-source-record-manager 19 mod-source-record-manager:3.10.11 2 4500 4000 64 3000 384 512 mod-source-record-manager - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-quick-marc 16 mod-quick-marc:7.0.0 1 2288 2176 64 1664 384 512 mod-quick-marc - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-feesfines 15 mod-feesfines:19.3.3 2 1024 896 64 768 88 128 mod-feesfines - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-users 6 edge-users:2.1.0-SNAPSHOT.1376.tls 2 1024 896 128 768 88 128 mod-service-interaction 16 mod-service-interaction:4.2.6 2 2048 1844 64 1290 384 512 mod-service-interaction - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-dcb 15 mod-dcb:1.3.10 2 2048 1844 64 1292 384 512 mod-dcb - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-patron 10 mod-patron:6.3.6 2 1024 896 64 768 88 128 mod-patron - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-connexion 9 edge-connexion:1.4.1.tls 2 1024 896 64 768 88 128 mod-data-export-spring 16 mod-data-export-spring:3.5.2 1 2048 1844 64 1536 384 512 mod-data-export-spring - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-organizations-storage 15 mod-organizations-storage:4.9.2 2 1024 896 64 700 88 128 mod-organizations-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-erm 8 edge-erm:1.4.1.tls 2 1024 896 64 768 88 128 mod-ncip 10 mod-ncip:1.16.1 2 1024 896 64 768 88 128 mod-ncip - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-agreements 18 mod-agreements:7.2.5 2 4096 4096 64 4096 0 0 mod-agreements - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-organizations 10 mod-organizations:2.1.1 2 1024 896 64 768 88 128 mod-organizations - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-serials-management 18 mod-serials-management:2.0.5 2 2780 2312 64 1792 384 896 mod-serials-management - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-settings 15 mod-settings:1.2.0 2 1024 896 64 768 88 128 mod-settings - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-dematic 10 edge-dematic:2.4.3.tls 1 1024 896 64 768 88 128 mod-data-import 17 mod-data-import:3.3.6 1 2048 1844 64 1292 384 512 mod-data-import - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-search 20 mod-search:5.0.13 2 2592 2480 64 1440 512 1024 mod-search - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-record-specifications 15 mod-record-specifications:2.0.3 2 2048 1592 64 1440 256 512 mod-record-specifications - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-inventory 5 edge-inventory:2.2.1-SNAPSHOT.1630.tls 2 1024 896 128 768 88 128 mod-orders-storage 23 mod-orders-storage:13.9.8 2 1024 896 64 700 88 128 mod-orders-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-erm-usage-harvester 14 mod-erm-usage-harvester:5.1.1 2 1024 896 64 768 88 128 mod-erm-usage-harvester - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-password-validator 16 mod-password-validator:3.4.1 2 1440 1298 64 768 384 512 mod-password-validator - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-fqm-manager 15 mod-fqm-manager:4.0.15 2 3000 2600 64 2048 88 512 mod-fqm-manager - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-dcb 10 edge-dcb:1.3.6.tls 2 1024 896 64 768 88 128 mod-bulk-operations 17 mod-bulk-operations:2.2.9 2 3072 2600 64 2048 384 512 mod-bulk-operations - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1500 768 64 256 0 128 mod-finance 16 mod-finance:5.1.3 2 1024 896 64 768 88 128 mod-finance - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-tlr 14 mod-tlr:1.1.9 2 1024 896 64 768 88 256 mod-tlr - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-lists 15 mod-lists:3.1.6 2 6000 2600 64 2048 88 512 mod-lists - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 768 715 64 256 0 96 mod-permissions 15 mod-permissions:6.7.1 2 1684 1544 64 1024 384 512 mod-permissions - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-users-keycloak 15 mod-users-keycloak:3.0.13.tls 4 4096 3688 128 3076 88 256 mod-users-keycloak - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-marc-migrations 13 mod-marc-migrations:2.0.5 2 2880 2592 64 1814 384 512 mod-marc-migrations - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mgr-applications 14 mgr-applications:3.0.6.tls 2 1024 896 64 512 88 256 mgr-tenants 12 mgr-tenants:3.0.6.tls 2 1024 896 64 512 88 256 edge-ea-data-export 1 edge-ea-data-export:4.4.0.tls 2 1024 896 64 768 88 128 edge-oai-pmh 9 edge-oai-pmh:2.11.1.tls 2 1512 1360 64 1440 384 512 mod-okapi-facade 14 mod-okapi-facade:3.0.0.tls 2 1024 896 64 768 88 128 mod-okapi-facade - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-rtac 14 mod-rtac:3.8.3 2 1024 896 64 768 88 128 mod-rtac - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-task-list 4 mod-task-list:1.10.0 2 1024 896 64 768 88 128 mod-task-list - Sidecar 1 N/A folio-module-sidecar:3.0.18.tls N/A 1024 512 64 256 0 96 mod-scheduler 16 mod-scheduler:3.0.9.tls 2 1024 896 64 512 88 256 mod-scheduler - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-circulation-bff 14 mod-circulation-bff:1.1.9 2 1024 896 64 768 88 128 mod-circulation-bff - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-inventory 23 mod-inventory:21.1.20 2 4096 3688 512 3076 384 512 mod-inventory - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 768 512 256 0 128 mod-requests-mediated 21 mod-requests-mediated:1.2.11 2 1500 1024 64 768 88 192 mod-requests-mediated - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-patron-blocks 15 mod-patron-blocks:1.12.3 2 1024 896 64 768 88 128 mod-patron-blocks - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 edge-fqm 8 edge-fqm:4.0.2.tls 2 1024 896 64 768 88 128 nginx-edge 5 nginx-edge:2025.09.19 2 1024 896 64 0 0 0 mod-invoice-storage 21 mod-invoice-storage:6.0.1 2 1872 1536 64 1024 384 512 mod-invoice-storage - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-reading-room 15 mod-reading-room:1.2.1 2 1024 896 64 768 88 128 mod-reading-room - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-data-export 15 mod-data-export:5.3.0 1 2592 2480 64 1440 88 1024 mod-data-export - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-oai-pmh 13 mod-oai-pmh:3.15.4 2 4096 3690 64 3076 384 512 mod-oai-pmh - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-notes 15 mod-notes:7.0.0 2 1024 896 64 952 384 512 mod-notes - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-kb-ebsco-java 15 mod-kb-ebsco-java:6.0.1 2 1024 896 64 768 88 128 mod-kb-ebsco-java - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96 mod-eusage-reports 14 mod-eusage-reports:3.0.0 2 1024 896 64 768 88 128 mod-eusage-reports - Sidecar 1 N/A folio-module-sidecar:3.0.19.tls N/A 1024 512 64 256 0 96

 

Methodology/Approach

  1. Preparation Steps:

Create 3000 open page requests with pick slips in them

DO $do$ DECLARE -- 1. ВСТАНОВІТЬ ВАШІ ПАРАМЕТРИ ТУТ _tenant text := 'cs00000int_0004'; _servicePointId uuid := 'a51ec277-5a45-471b-9306-3c88afc003d9'; -- Автоматичний підбір системних ID _locationId uuid := '36d0bab6-34fe-48e4-988e-b93b9e251c21'; _materialType uuid := (SELECT id FROM cs00000int_0004_mod_inventory_storage.material_type LIMIT 1); _loanType uuid := (SELECT id FROM cs00000int_0004_mod_inventory_storage.loan_type LIMIT 1); _instanceType uuid := (SELECT id FROM cs00000int_0004_mod_inventory_storage.instance_type LIMIT 1); _requesterId uuid := 'fd571f78-e05c-4a11-8e73-fb1b3ae933c9'; _instanceId uuid := uuid_generate_v4(); _holdingsId uuid := uuid_generate_v4(); _itemId uuid; _requestId uuid; _itemBarcode text; _count int := 15; BEGIN RAISE NOTICE 'Починаю генерацію 100к записів з типом HOLD для точки %...', _servicePointId; -- Створення Instance INSERT INTO cs00000int_0004_mod_inventory_storage.instance (id, jsonb) VALUES ( _instanceId, jsonb_build_object( 'id', _instanceId, 'title', 'PERF1310- PERF TEST HOLD', 'source', 'FOLIO', 'instanceTypeId', _instanceType, 'hrid', 'inst-' || substr(uuid_generate_v4()::text, 1, 8) ) ); -- Створення Holdings Record INSERT INTO cs00000int_0004_mod_inventory_storage.holdings_record (id, jsonb) VALUES ( _holdingsId, jsonb_build_object( 'id', _holdingsId, 'instanceId', _instanceId, 'permanentLocationId', _locationId, 'effectiveLocationId', _locationId, 'hrid', 'hold-' || substr(uuid_generate_v4()::text, 1, 8) ) ); FOR i IN 1.._count LOOP _itemId := uuid_generate_v4(); _requestId := uuid_generate_v4(); _itemBarcode := 'HOLD-BC-' || i || '-' || substr(_itemId::text, 1, 5); -- Вставка Item INSERT INTO cs00000int_0004_mod_inventory_storage.item (id, jsonb) VALUES ( _itemId, jsonb_build_object( 'id', _itemId, 'holdingsRecordId', _holdingsId, 'barcode', _itemBarcode, 'status', jsonb_build_object('name', 'Available'), 'materialTypeId', _materialType, 'permanentLoanTypeId', _loanType, 'effectiveLocationId', _locationId ) ); -- Вставка Request з типом "Hold" (вимога кроку 4) INSERT INTO cs00000int_0004_mod_circulation_storage.request (id, jsonb) VALUES ( _requestId, jsonb_build_object( 'id', _requestId, 'itemId', _itemId, 'instanceId', _instanceId, 'holdingsRecordId', _holdingsId, 'requestType', 'Page', 'requestLevel', 'Item', 'requestDate', to_char(now(), 'YYYY-MM-DD"T"HH24:MI:SS.MS"Z"'), 'status', 'Open - Not yet filled', 'fulfillmentPreference', 'Hold Shelf', 'requesterId', _requesterId, 'pickupServicePointId', _servicePointId, -- Саме цей ID буде в URL API 'item', jsonb_build_object( 'barcode', _itemBarcode ) ) ); IF i % 20000 = 0 THEN RAISE NOTICE 'Генерація: % завершено...', i; END IF; END LOOP; RAISE NOTICE 'Успішно згенеровано 100,000 запитів типу HOLD.'; END $do$;
  1. Test Configuration:

30-minute test with 10 users invoking the following API: /circulation/pick-slips/{servicePointId}.
Script location: /home/ptf/testdata/selctls2/PERF-1310/1310.jmx