Overview

This document summarizes the results of Bulk Edit parameter testing performed changing the mod-data-export-worker task definition parameters. Various parameter configurations were evaluated using a file with 50,000 item records. The test scenarios involved applying a single change to each record—specifically, the addition of an extra note to Note field.
Sunflower release on a non-ecs environment ( secp1 in our case, central tenant - fs09000000).
Test results contain two parts. First is file upload and retrieving data. The second part is applying changes. Parameter value changes intend to help reduce duration of the first part of test.
Jira PERF-1164 - Getting issue details... STATUS

Summary

All tests completed successfully.
Best results achieved in test number 5 with MERGE_CSV_JSON_MRC_POOL_SIZE parameter equal 2. Combining parameters with best cases reveal negative effect. All other test results and observations exposed in the table below:

Parameters	Tests	Total Duration (min)	Notes
QUANTITY_PER_PARTITION	Test2–4	49, 50, 48	Slightly better than baseline; stable performance
MERGE_CSV_JSON_MRC_POOL_SIZE	Test5–7	47, 62, 56	High variability; possible tuning impact
NUM_PARTITIONS	Test8–10	67, 51, 53	One test caused significant slowdown (Test8: 67)
DB_POOL_SIZE	Test11–13	52, 52, 51	Very consistent results; no performance gain
QUANTITY_PER_PARTITION + MERGE_CSV_JSON_MRC_POOL_SIZE	Test15	62	Combined change shows degraded performance
All Parameters Combined	Test14	72	Worst performance; suggests negative cumulative effect

The 50k file upload and retrieving data part perform better in test #4 - 4 minutes. Test #5 show the same results as default - 5 minutes.
Memory consumption for all modules shows a stable trend. No memory leaks are suspected.
Service CPU utilization corresponded to the load.
- Top 5 services CPU utilization: mod-inventory-storage-b=121%, mod-inventory-b=53%, mod-data-export-worker-b=31%, mod-inn-reach-b=13%, mod-audit-b=10%
Service memory consumption
- mod-bulk-operations-b=61%, edge-users-b=42%, mod-search-b=40%, mod-data-export-worker-b=40%, mod-source-record-storage-b=34%, mod-inventory-b=33%, mod-data-export-b=29%, mod-circulation-b=26%, mod-inventory-storage-b=25%, kong-b=12%
DB CPU utilization was 29% mostly. Combined scenario and test #6 which is performed worse - 36%. During test #6 there's a spike to 52% once after data retrieved and before applying changes.
DB connections - 1280 all tests.
Retest of test #14 was conducted only for the first part - retrieving data. It took 5 minutes and 35 seconds. Retest of test #5 took 4 minutes and 40 seconds. So cumulative negative affect confirmed. Degradation in average - 1 minute or 20%.

Jiras

Test description

Identifier

Record identifier

Number of records

Action

mod-data-export-worker parameter

records source

Inventory-Items

Item barcodes

50 000

Adding a note "ptf_test" in Note field

Applying single variable each test

QUANTITY_PER_PARTITION

MERGE_CSV_JSON_MRC_POOL_SIZE

NUM_PARTITIONS

DB_POOL_SIZE

from .csv file

Test runs

Tests	Task definition	mod-data-export-worker parameter	Value
Test #1	Default values	QUANTITY_PER_PARTITION	5000
		MERGE_CSV_JSON_MRC_POOL_SIZE	3
		NUM_PARTITIONS	8
		DB_POOL_SIZE	20
Test #2	secp1-mod-data-export-worker:10	QUANTITY_PER_PARTITION	3000
Test #3	secp1-mod-data-export-worker:11	QUANTITY_PER_PARTITION	4000
Test #4	secp1-mod-data-export-worker:12	QUANTITY_PER_PARTITION	7000
Test #5	secp1-mod-data-export-worker:14	MERGE_CSV_JSON_MRC_POOL_SIZE	2
Test #6	secp1-mod-data-export-worker:15	MERGE_CSV_JSON_MRC_POOL_SIZE	5
Test #7	secp1-mod-data-export-worker:16	MERGE_CSV_JSON_MRC_POOL_SIZE	7
Test #8	secp1-mod-data-export-worker:17	NUM_PARTITIONS	2
Test #9	secp1-mod-data-export-worker:18	NUM_PARTITIONS	10
Test #10	secp1-mod-data-export-worker:19	NUM_PARTITIONS	15
Test #11	secp1-mod-data-export-worker:20	DB_POOL_SIZE	15
Test #12	secp1-mod-data-export-worker:21	DB_POOL_SIZE	30
Test #13	secp1-mod-data-export-worker:22	DB_POOL_SIZE	40
Test #14	secp1-mod-data-export-worker:23	QUANTITY_PER_PARTITION	7000
		MERGE_CSV_JSON_MRC_POOL_SIZE	2
		NUM_PARTITIONS	10
		DB_POOL_SIZE	40
Test #15	secp1-mod-data-export-worker:24	QUANTITY_PER_PARTITION	7000
Test #15	secp1-mod-data-export-worker:24	MERGE_CSV_JSON_MRC_POOL_SIZE	2
Test #16 - retest #14	secp1-mod-data-export-worker:23

Test Results

Test #	Parameter change	Upload Duration (minutes)	Applying changes Duration (minutes)	Total time	Results
Test1	default	5	47	52	Completed
Test2	QUANTITY_PER_PARTITION	6	43	49	Completed
Test3	QUANTITY_PER_PARTITION	7	43	50	Completed
Test4	QUANTITY_PER_PARTITION	5	43	48	Completed
Test5	MERGE_CSV_JSON_MRC_POOL_SIZE	4	43	47	Completed
Test6	MERGE_CSV_JSON_MRC_POOL_SIZE	4	58	62	Completed
Test7	MERGE_CSV_JSON_MRC_POOL_SIZE	4	52	56	Completed
Test8	NUM_PARTITIONS	7	60	67	Completed
Test9	NUM_PARTITIONS	5	46	51	Completed
Test10	NUM_PARTITIONS	5	48	53	Completed
Test11	DB_POOL_SIZE	5	47	52	Completed
Test12	DB_POOL_SIZE	5	47	52	Completed
Test13	DB_POOL_SIZE	5	46	51	Completed
Test14	QUANTITY_PER_PARTITION/MERGE_CSV_JSON_MRC_POOL_SIZE/NUM_PARTITIONS/DB_POOL_SIZE	7	65	72	Completed
Test15	QUANTITY_PER_PARTITION/MERGE_CSV_JSON_MRC_POOL_SIZE	7	55	62	Completed
Test16	Retest #14	6	not tested		Completed

Resource utilization

Service CPU Utilization

Service Memory Utilization

Tests #1 - #7

Tests #8 - #14

DB CPU Utilization

Tests #1 - #7

Tests #8 - #14

DB Connections

Tests #1 - #7

Tests #8 - #14

DB load

Tests #1 - #7

Tests #8 - #14

Top SQL-queries

Tests #1 - #7

Tests #8 - #14

Appendix

Infrastructure

PTF - environment Ramsons (secp1)

14 r7g.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instance, writer
Name Memory GIB vCPUs
db.r6g.xlarge
32 GiB 4 vCPUs
MSK fse-test
- 4 kafka.m7g.xlarge brokers in 2 zones
- Apache Kafka version 3.7.x
- EBS storage volume per broker 300 GiB
- auto.create.topics.enable=true
- log.retention.minutes=480
- default.replication.factor=2

Sunflower services resources

Cluster Resources - secp1-pvt (Mon Aug 04 08:03:13 UTC 2025)

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	8	mod-remote-storage:3.4.3	2	4920	4472	128	3960	512	512
mod-remote-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-finance-storage	8	mod-finance-storage:8.8.4	2	1024	896	128	700	88	128
mod-finance-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-ebsconet	7	mod-ebsconet:2.4.0	2	1248	1024	128	700	128	256
mod-ebsconet - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-sip2	7	edge-sip2:3.4.1	2	1024	896	128	768	88	128
mod-consortia-keycloak	6	mod-consortia-keycloak:1.7.1	2	5136	4776	512	4416	384	512
mod-consortia-keycloak - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-tags	8	mod-tags:2.4.1	2	1024	896	128	768	88	128
mod-tags - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-courses	7	edge-courses:1.6.0	2	1024	896	128	768	88	128
mod-inventory-update	7	mod-inventory-update:4.1.0	2	1024	896	128	768	88	128
mod-inventory-update - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-notify	8	mod-notify:3.4.0	2	1024	896	128	768	88	128
mod-notify - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-configuration	8	mod-configuration:5.12.0	2	1024	896	128	768	88	128
mod-configuration - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
folio-keycloak	11	folio-keycloak:26.1.3	1	5000	3000	2048	2048	0	0
edge-caiasoft	7	edge-caiasoft:2.4.0	2	1024	896	128	768	88	128
mod-licenses	8	mod-licenses:6.2.2	2	2480	2312	512	1792	384	512
mod-licenses - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-gobi	8	mod-gobi:3.0.0	2	1024	896	128	768	88	128
mod-gobi - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-graphql	8	mod-graphql:1.13.1	2	1024	896	128	768	88	128
mod-graphql - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-roles-keycloak	8	mod-roles-keycloak:3.0.3	2	1024	896	128	512	88	256
mod-roles-keycloak - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-erm-usage	5	mod-erm-usage:5.0.0	2	2800	2550	128	1800	384	512
mod-erm-usage - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-batch-print	7	mod-batch-print:1.3.0	2	1024	896	128	768	88	128
mod-batch-print - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-copycat	8	mod-copycat:1.8.0	2	1024	896	128	768	88	128
mod-copycat - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-entities-links	8	mod-entities-links:4.0.3	2	2592	2483	512	1440	0	1024
mod-entities-links - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
pub-edge	8	pub-edge:2023.06.14	2	1024	896	128	768	0	0
mod-orders	8	mod-orders:13.0.5	2	2048	1740	1024	1024	384	512
mod-orders - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
kong	13	kong:3.9.0	1	6144	6144	2048	768	88	128
edge-patron	8	edge-patron:5.3.0	2	1024	896	256	768	88	128
edge-ncip	7	edge-ncip:1.10.2	2	1024	896	128	768	88	128
edge-inn-reach	1	edge-inn-reach:3.4.0	2	1024	896	128	768	88	128
mod-users-bl	8	mod-users-bl:7.10.2	2	1440	1152	128	922	88	128
mod-users-bl - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-invoice	8	mod-invoice:6.0.1	2	1440	1152	512	922	88	128
mod-invoice - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-inventory-storage	8	mod-inventory-storage:29.0.11	2	4096	3690	1024	3067	384	512
mod-inventory-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	768	512	256	0	128
mod-user-import	7	mod-user-import:3.10.1	2	1024	896	128	768	88	128
mod-user-import - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-sender	8	mod-sender:1.14.1	2	1024	896	128	768	88	128
mod-sender - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mgr-tenant-entitlements	6	mgr-tenant-entitlements:3.1.1	1	1024	896	1024	512	88	256
mod-data-export-worker	24	mod-data-export-worker:3.4.6	2	3072	2800	1024	2048	384	512
mod-data-export-worker - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	768	512	256	0	128
mod-circulation-storage	8	mod-circulation-storage:17.4.0	2	2880	2592	1024	1814	384	512
mod-circulation-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
mod-calendar	8	mod-calendar:3.3.0	2	2048	1536	128	768	88	128
mod-calendar - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-event-config	8	mod-event-config:2.9.0	2	1024	896	128	768	88	128
mod-event-config - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-courses	8	mod-courses:1.4.12	2	1024	896	128	768	88	128
mod-courses - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-circulation-item	5	mod-circulation-item:1.1.0	2	1024	896	128	0	0	0
mod-circulation-item - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-email	8	mod-email:1.19.0	2	2800	2550	128	1800	384	512
mod-email - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-pubsub	8	mod-pubsub:2.16.1	2	1536	1440	1024	922	384	512
mod-pubsub - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
mod-di-converter-storage	8	mod-di-converter-storage:2.4.2	2	1024	896	128	768	88	128
mod-di-converter-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-circulation	8	mod-circulation:24.4.7	2	2880	2592	1024	1814	384	512
mod-circulation - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
edge-orders	7	edge-orders:3.2.0	2	1024	896	128	768	88	128
edge-rtac	7	edge-rtac:2.9.1	2	1024	896	128	768	88	128
mod-users	10	mod-users:19.5.1	2	1024	896	256	768	88	128
mod-users - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-template-engine	8	mod-template-engine:1.22.0	2	1024	896	128	768	88	128
mod-template-engine - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-audit	9	mod-audit:2.11.1	2	1024	896	128	768	88	128
mod-audit - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-source-record-manager	8	mod-source-record-manager:3.10.6	2	4096	3688	1024	3076	384	512
mod-source-record-manager - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-quick-marc	8	mod-quick-marc:7.0.0	1	2288	2176	128	1664	384	512
mod-quick-marc - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-feesfines	8	mod-feesfines:19.3.2	2	1024	896	128	768	88	128
mod-feesfines - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-users	4	edge-users:2.0.0	2	1024	896	128	768	88	128
mod-dcb	8	mod-dcb:1.2.11	2	2048	1844	128	1292	384	512
mod-dcb - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-service-interaction	7	mod-service-interaction:4.2.2	2	2048	1844	256	1290	384	512
mod-service-interaction - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-patron	8	mod-patron:6.3.1	2	1024	896	128	768	88	128
mod-patron - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-connexion	8	edge-connexion:1.4.1	2	1024	896	128	768	88	128
mod-data-export-spring	8	mod-data-export-spring:3.5.2	1	2048	1844	256	1536	384	512
mod-data-export-spring - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-erm	7	edge-erm:1.4.0	2	1024	896	128	768	88	128
mod-ncip	7	mod-ncip:1.15.7	2	1024	896	128	768	88	128
mod-ncip - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-agreements	8	mod-agreements:7.2.2	2	4096	4096	1024	4096	0	0
mod-agreements - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
mod-organizations	8	mod-organizations:2.1.0	2	1024	896	128	620	88	128
mod-organizations - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-settings	8	mod-settings:1.2.0	2	1024	896	200	768	88	128
mod-settings - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-search	8	mod-search:5.0.4	2	2592	2480	1024	1440	512	1024
mod-search - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-dematic	7	edge-dematic:2.4.2	1	1024	896	128	768	88	128
mod-data-import	8	mod-data-import:3.3.4	1	2048	1844	256	1292	384	512
mod-data-import - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-record-specifications	7	mod-record-specifications:2.0.1	2	1024	896	400	1440	256	512
mod-record-specifications - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-inn-reach	2	mod-inn-reach:3.4.0	2	3600	3240	128	2880	512	1024
mod-inn-reach - Sidecar 1	N/A	folio-module-sidecar:3.0.4	N/A	1024	512	128	256	0	96
edge-inventory	4	edge-inventory:2.1.3	2	1024	896	128	768	88	128
mod-orders-storage	8	mod-orders-storage:13.9.4	2	1024	896	512	700	88	128
mod-orders-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-erm-usage-harvester	5	mod-erm-usage-harvester:5.0.2	2	1024	896	128	768	88	128
mod-erm-usage-harvester - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-password-validator	8	mod-password-validator:3.4.0	2	1440	1298	128	768	384	512
mod-password-validator - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-bulk-operations	8	mod-bulk-operations:2.2.5	2	3072	2600	1024	2048	384	512
mod-bulk-operations - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1500	768	512	256	0	128
mod-fqm-manager	7	mod-fqm-manager:4.0.10	2	3000	2600	128	2048	88	512
mod-fqm-manager - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
edge-dcb	5	edge-dcb:1.2.4	2	1024	896	128	768	88	128
mod-finance	8	mod-finance:5.1.1	2	1024	896	256	768	88	128
mod-finance - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-tlr	2	mod-tlr:1.0.17	2	1024	896	128	768	88	256
mod-tlr - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-lists	7	mod-lists:3.1.5	2	6000	2600	128	2048	88	512
mod-lists - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	768	715	128	256	0	96
mod-permissions	8	mod-permissions:6.7.0	2	1684	1544	512	1024	384	512
mod-permissions - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
mod-users-keycloak	8	mod-users-keycloak:3.0.3	2	1024	896	128	512	88	256
mod-users-keycloak - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-marc-migrations	5	mod-marc-migrations:2.0.1	2	2880	2592	1024	1814	384	512
mod-marc-migrations - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mgr-applications	5	mgr-applications:3.0.0	1	1024	896	1024	512	88	256
mgr-tenants	5	mgr-tenants:3.0.0	1	1024	896	1024	512	88	256
edge-oai-pmh	7	edge-oai-pmh:2.11.0	2	1512	1360	1024	1440	384	512
mod-okapi-facade	8	mod-okapi-facade:3.0.0	2	1024	896	128	768	88	128
mod-okapi-facade - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-rtac	8	mod-rtac:3.8.0	2	1024	896	128	768	88	128
mod-rtac - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-source-record-storage	8	mod-source-record-storage:5.10.9	2	4096	3688	1024	3076	384	512
mod-source-record-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-scheduler	8	mod-scheduler:3.0.1	2	1024	896	128	512	88	256
mod-scheduler - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-circulation-bff	2	mod-circulation-bff:1.0.20	2	1024	896	128	768	88	128
mod-circulation-bff - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-inventory	8	mod-inventory:21.1.7	2	4096	3688	1024	3076	384	512
mod-inventory - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	768	512	256	0	128
mod-requests-mediated	2	mod-requests-mediated:1.0.17	2	1500	1024	128	768	88	192
mod-requests-mediated - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96
mod-linked-data	2	mod-linked-data:1.0.4	2	2048	1792	256	768	88	128
mod-linked-data - Sidecar 1	N/A	folio-module-sidecar:3.0.4	N/A	1024	512	128	256	0	96
mod-patron-blocks	8	mod-patron-blocks:1.12.1	2	1024	896	1024	620	88	128
mod-patron-blocks - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
edge-fqm	7	edge-fqm:4.0.1	2	1024	896	128	768	88	128
nginx-edge	7	nginx-edge:2023.06.14	2	1024	896	128	0	0	0
mod-invoice-storage	8	mod-invoice-storage:6.0.0	2	1872	1536	0	1024	384	512
mod-invoice-storage - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-reading-room	7	mod-reading-room:1.2.1	2	1024	896	128	768	88	128
mod-reading-room - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-data-export	8	mod-data-export:5.2.2	1	2592	2480	2048	1440	88	1024
mod-data-export - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
mod-oai-pmh	8	mod-oai-pmh:3.15.2	2	4096	3690	2048	3076	384	512
mod-oai-pmh - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	256	256	0	96
mod-notes	8	mod-notes:7.0.0	2	1024	896	128	952	384	512
mod-notes - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-kb-ebsco-java	7	mod-kb-ebsco-java:6.0.0	2	1024	896	128	768	88	128
mod-kb-ebsco-java - Sidecar 1	N/A	folio-module-sidecar:3.0.5	N/A	1024	512	128	256	0	96
mod-eusage-reports	5	mod-eusage-reports:3.0.0	2	1024	896	128	768	88	128
mod-eusage-reports - Sidecar 1	N/A	folio-module-sidecar:3.0.4.455.nb	N/A	1024	512	128	256	0	96

Methodology/Approach

Test set

Data preparation: prepare . csv file with 50000 item barcodes for testing
The script to prepare files is here.

In case of testing with instances - populate the database with FOLIO records if needed with this script.

Manually tested. All tests triggered on one tenant only:
1. Trigger bulk edit by submitting identifiers for 50000 item records
2. Wait until Bulk edit finds all matched records and record the startTime and endTime of the process from the response.
3. Edit instances and start the second part of the bulk edit to commit the changes.
4. Record the start time of committing changes from Headers
Database preparation script after the test run required to restore Suppress from discovery and Staff suppress parameters.

Additional screenshots

Name	Memory GIB	vCPUs
db.r6g.xlarge	32 GiB	4 vCPUs

[Sunflower] [non-ECS] Bulk Edit Parameters Testing with Item records

Overview

Summary

Jiras

Test description

Test runs

Test Results

Resource utilization

Service Memory Utilization

DB CPU Utilization

DB Connections

DB load

Top SQL-queries

Infrastructure

Methodology/Approach