Table of Contents

outline	true

...

This document contains the results of testing RMB connection caching implementation. Ticket: PERF-815

Jira Legacy

server	System Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	01505d01-b853-3c2e-90f1-ee9b165564fc
key	PERF-815

...

Compares results of Base Line test(DB_MAXPOOLSIZE=20), Test №1(mod-inventory-storage=40) and Test №2(mod-inventory-storage=40 plus mod-circulation-storage=40) show that shared pool feature leads to performance degradation.
The CI/CO response time for Test №3 and Test №3 RERUN (mod-invetory-storage=2500, mod-circulation-storage=500) is lower, and it has a higher number of database connections compared to the previous test run. These results indicate an improvement in performance attributed to the MAXSHAREDPOOLSIZE parameter.
Almost all tests involving data import are experiencing errors due to database connection timeouts. More details about errors in the Discussion section.
During the comparison test between DB_MAXSHAREDPOOLSIZE = 70 and DB_MAXSHAREDPOOLSIZE = 40, we observed a significant decrease in response time, and importantly, all 15 data imports were successful.
When comparing tests with data import for 30 tenants, the test with DB_MAXSHAREDPOOLSIZE=280 stands out. It demonstrates the stable response time and, crucially, successful data import for all 30 tenants.
All tests have Check-In errors for tenant 8, looks like a problem with data preparation for 8 tenant.
For test №7, 8 and 10 we observe different count of tenants used for data import, but was set 61.

Test Runs

Test №

Date

Date (UA time zone)	Test Conditions	Results
Baseline Test	2/29/2024, 12:47:18 PM	DB_MAXPOOLSIZE=20 for list of modules CICO=8 users, Data Import=25K for ONE tenant	Completed
1	03.08.2024 13:34:08	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=40 (per task, 2 tasks = 80 connections total) other modules DB_MAXPOOLSIZE=20 CICO=8 users, Data Import=25K for ONE tenant	Completed
2	03.08.2024 15:23:46	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=40 (per task, 2 tasks = 80 connections total) mod-circulation-storage DB_MAXSHAREDPOOLSIZE=40 others modules DB_MAXPOOLSIZE=20 CICO=8 users, Data Import=25K for ONE tenant	Completed
3	3/9/2024, 4:35:33 PM (UA) 3/9/2024, 1:35:33 PM (UTC)	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500 mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 others modules DB_MAXPOOLSIZE=20 CICO=305 users for 61 tenants	Completed
3 RERUN	4/2/2024, 4:30:01 PM	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500 mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 others modules DB_MAXPOOLSIZE=20 CICO=305 users for 61 tenants	Completed
4	3/11/2024, 5:50:25 PM	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500 mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 Others modules DB_MAXPOOLSIZE=20 CICO=305 users for 61 tenants, Data Import=10K for 15 tenants	Completed
5	3/12/2024, 12:03:05 PM	DB_MAXSHAREDPOOLSIZE=40 CICO=305 users for 61 tenants, Data Import=10K for 15 tenants	Failed Data Import
6	3/12/2024, 14:03:50	DB_MAXSHAREDPOOLSIZE=70 CICO=305 users for 61 tenants, Data Import=10K for 15 tenants	Completed
7	3/12/2024, 20:23:01	DB_MAXSHAREDPOOLSIZE=140 CICO=305 users for 61 tenants(56), Data Import=10K for 30 tenants	Completed
8	3/13/2024, 7:46:49 PM	DB_MAXSHAREDPOOLSIZE=210 CICO=305 users for 61 tenants(48), Data Import=10K for 30 tenants	Completed
9	3/14/2024, 12:47:15 PM	DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage DB_MAXSHAREDPOOLSIZE=70 for others CICO=305 users for 61 tenants, Data Import=10K for 30 tenants	Completed
10	3/15/2024, 11:42:14 AM	DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage DB_MAXSHAREDPOOLSIZE=140 for others CICO=305 users for 61 tenants(41), Data Import=10K for 30 tenants	Completed
11	3/15/2024, 3:19:02 PM	DB_MAXSHAREDPOOLSIZE=280 CICO=305 users for 61 tenants, Data Import=10K for 30 tenants	Completed

Test Results

Baseline Test

...

DB_MAXSHAREDPOOLSIZE=140 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	128	1.218	1.426	5.235	15.570	1.866	0	1:44:56	PARSING	ERROR
CICO_TC_Check-Out	124	2.251	2.627	12.493	20.318	3.551	0	1:44:56	9	8

Expand

title	Full Check-In/Check-Out result table

Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
124	124	0	0	0.07	0.661	1.229	1.469	9.657	19.285	26.413	2.324	9.384
124	124	0	0	0.07	0.666	1.224	1.431	9.417	23.386	31.748	2.267	9.236
122	122	0	0	0.068	0.776	1.216	1.403	9.126	19.771	20.475	2.16	9.042
123	123	0	0	0.071	0.699	1.242	1.486	7.154	16.663	33.269	2.061	7.08
120	120	0	0	0.069	0.686	1.216	1.442	4.924	12.871	19.068	1.765	4.792
117	117	0	0	0.066	0.65	1.256	1.471	4.059	14.63	24.498	1.886	3.99
113	113	0	0	0.064	0.729	1.239	1.395	9.455	17.489	17.949	2.149	9.379
124	124	0	0	0.073	0.605	1.268	1.489	7.74	14.954	32.17	2.165	7.586
102	102	0	0	0.058	0.694	1.169	1.371	3.967	15.608	18.114	1.796	3.883
117	117	0	0	0.068	0.672	1.269	1.524	7.906	18.814	31.226	2.217	7.815
125	125	0	0	0.074	0.706	1.194	1.437	3.499	13.193	14.31	1.609	3.391
120	120	0	0	0.07	0.735	1.306	1.487	6.13	17.316	18.012	1.955	5.998
125	125	0	0	0.072	0.693	1.215	1.457	7.588	19.73	21.34	2.062	7.473
125	125	0	0	0.071	0.755	1.265	1.442	6.147	15.066	24.213	1.899	6.044
113	113	0	0	0.064	0.745	1.256	1.492	10.489	16.41	25.444	2.321	10.339
135	135	0	0	0.077	0.733	1.249	1.502	6.203	20.159	20.689	2.054	6.118
116	116	0	0	0.065	0.692	1.248	1.441	3.584	12.902	15.757	1.742	3.472
116	116	0	0	0.068	0.659	1.254	1.403	3.387	20.001	23.095	1.88	3.203
126	126	0	0	0.072	0.656	1.214	1.455	7.113	15.582	19.805	1.884	6.754
112	112	0	0	0.064	0.73	1.25	1.479	2.576	16.352	30.931	1.871	2.476
128	128	0	0	0.073	0.744	1.181	1.37	4.609	15.572	31.669	1.842	4.542
119	119	0	0	0.07	0.749	1.234	1.458	5.591	19.325	26.345	2.056	5.429
125	125	0	0	0.071	0.731	1.213	1.422	5.398	14.128	17.895	1.83	5.263
118	118	0	0	0.069	0.708	1.228	1.456	5.238	18.247	19.402	1.955	5.151
111	111	0	0	0.065	0.706	1.23	1.48	4.753	16.453	30.98	1.934	4.514
107	107	0	0	0.06	0.727	1.187	1.386	2.855	13.877	14.8	1.559	2.733
115	115	0	0	0.068	0.658	1.212	1.419	2.735	12.485	21.686	1.731	2.515
123	123	0	0	0.071	0.738	1.227	1.478	2.282	13.403	16.207	1.687	2.189
117	117	0	0	0.067	0.627	1.281	1.501	9.61	21.871	22.727	2.216	9.496
126	126	0	0	0.071	0.717	1.254	1.474	3.818	16.316	25.664	1.911	3.711
117	117	0	0	0.067	0.736	1.234	1.455	5.046	17.398	20.664	1.964	4.935
119	119	0	0	0.067	0.682	1.188	1.391	4.209	11.34	12.975	1.578	4.115
123	123	0	0	0.072	0.75	1.29	1.515	5.907	20.165	29.482	2.151	5.838
115	115	0	0	0.065	0.727	1.213	1.445	2.473	13.561	15.464	1.61	2.202
108	108	0	0	0.062	0.692	1.253	1.52	5.807	11.997	17.211	1.749	5.672
112	112	0	0	0.065	0.68	1.212	1.421	6.996	12.067	13.105	1.806	6.905
111	111	0	0	0.064	0.67	1.213	1.367	6.897	15.682	21.612	1.946	6.749
117	117	0	0	0.07	0.693	1.177	1.373	3.222	16.231	24.26	1.803	3.146
124	124	0	0	0.071	0.671	1.226	1.418	4.014	14.166	30.227	1.82	3.862
111	111	0	0	0.063	0.747	1.189	1.331	4.863	13.041	16.615	1.766	4.623
113	113	0	0	0.068	0.632	1.222	1.392	1.882	14.817	16.579	1.642	1.777
120	120	0	0	0.068	0.734	1.217	1.436	7.01	17.026	23.545	2.01	6.885
114	114	0	0	0.068	0.612	1.223	1.389	1.862	15.544	17.436	1.611	1.604
119	119	0	0	0.068	0.717	1.169	1.385	2.416	8.431	17.256	1.585	2.318
224	224	0	0	0.131	0.651	1.147	1.333	5.351	13.585	16.724	1.684	5.206
118	118	0	0	0.071	0.69	1.184	1.443	6.841	16.377	20.653	1.913	6.719
225	225	0	0	0.13	0.643	1.111	1.322	2.974	12.033	15.341	1.452	2.82
118	118	0	0	0.068	0.667	1.2	1.378	1.775	8.308	9.358	1.368	1.654
249	249	0	0	0.139	0.634	1.148	1.333	7.178	16.754	24.04	1.859	7.074
102	102	0	0	0.059	0.647	1.202	1.367	3.551	14.876	19.811	1.699	3.397
253	253	0	0	0.143	0.673	1.124	1.327	2.935	11.83	20.785	1.592	2.841
108	108	0	0	0.063	0.701	1.246	1.428	5.335	15.738	20.536	1.95	5.255
241	241	0	0	0.137	0.654	1.13	1.313	4.745	16.187	20.966	1.657	4.644
119	119	0	0	0.071	0.629	1.186	1.43	5.725	20.26	24.06	2.065	5.558
113	0	113	100	0	0.736	1.226	1.414	2.291	13.071	13.521	1.714	2.169
114	114	0	0	0.065	0.692	1.248	1.418	4.866	9.562	18.414	1.688	4.598
110	110	0	0	0.064	1.444	2.252	2.607	14.936	23.264	31.468	3.6	14.739
107	107	0	0	0.064	1.448	2.217	2.579	14.82	24.978	32.653	3.827	14.638
111	111	0	0	0.064	1.428	2.219	2.559	12.397	23.074	27.293	3.859	12.263
109	109	0	0	0.062	1.5	2.276	2.728	13.756	22.313	30.794	3.864	13.526
113	113	0	0	0.063	1.392	2.27	2.608	12.769	29.498	31.03	4.066	12.496
115	115	0	0	0.068	1.407	2.211	2.665	12.747	16.986	23.201	3.571	12.301
118	118	0	0	0.068	1.344	2.223	2.626	14.883	21.735	29.39	3.809	14.573
108	108	0	0	0.062	1.455	2.28	2.504	13.503	17.645	28.174	3.477	13.19
129	129	0	0	0.075	1.415	2.267	2.805	15.5	20.095	20.991	3.85	15.334
116	116	0	0	0.067	1.437	2.311	2.574	9.828	15.288	20.358	3.39	9.659
108	108	0	0	0.061	1.58	2.381	2.994	13.607	24.466	29.191	4.096	13.163
111	111	0	0	0.064	1.486	2.225	2.703	12.389	20.159	31.5	3.579	12.236
107	107	0	0	0.06	1.447	2.281	2.804	14.518	30.271	31.745	4.096	14.324
106	106	0	0	0.063	1.491	2.368	2.673	13.076	27.145	32.18	3.677	12.853
119	119	0	0	0.068	1.361	2.258	2.676	13.535	18.065	21.007	3.47	13.381
96	96	0	0	0.057	1.491	2.377	2.672	14.298	22.701	31.942	3.902	14.173
116	116	0	0	0.068	1.419	2.287	2.684	13.141	19.313	30.326	3.812	12.885
115	115	0	0	0.066	1.466	2.314	2.627	11.849	16.013	16.949	3.221	11.566
108	108	0	0	0.061	1.451	2.275	2.698	14.338	18.915	20.394	3.464	14.178
119	119	0	0	0.069	1.486	2.274	2.691	12.992	19.363	32.684	3.778	12.702
104	104	0	0	0.061	1.469	2.238	2.47	15.658	21.063	27.452	3.687	15.403
113	113	0	0	0.064	1.552	2.332	2.653	9.563	13.549	16.513	3.105	9.425
107	107	0	0	0.064	1.573	2.272	2.59	15.481	19.99	32.137	3.715	15.336
114	114	0	0	0.064	1.408	2.283	2.697	7.716	13.703	14.899	3.009	7.581
120	120	0	0	0.068	1.314	2.255	2.51	13.502	28.689	31.492	3.739	13.236
125	125	0	0	0.073	1.526	2.196	2.55	11.805	19.042	21.913	3.348	11.678
116	116	0	0	0.067	1.444	2.32	2.853	10.091	15.857	20.377	3.464	9.869
110	110	0	0	0.062	1.4	2.329	2.583	12.063	17.51	31.943	3.487	11.928
113	113	0	0	0.066	1.426	2.233	2.611	10.752	20.05	24.492	3.39	10.568
107	107	0	0	0.063	1.449	2.238	2.725	16.715	17.596	33.243	3.736	16.541
114	114	0	0	0.065	1.471	2.179	2.568	12.706	19.746	24.174	3.568	12.162
113	113	0	0	0.065	1.476	2.257	2.775	10.137	26.525	31.03	3.589	10.012
109	109	0	0	0.063	1.326	2.367	2.725	8.045	21.094	24.443	3.187	7.883
118	118	0	0	0.068	1.23	2.285	2.691	12.537	19.44	31.771	3.75	12.427
124	124	0	0	0.072	1.392	2.227	2.556	9.482	20.2	31.204	3.28	9.139
121	121	0	0	0.068	1.487	2.226	2.532	7.609	16.169	21.283	3.04	7.417
122	122	0	0	0.07	1.337	2.189	2.603	14.037	15.801	24.815	3.24	13.882
116	116	0	0	0.065	1.478	2.305	2.568	11.941	17.019	28.292	3.585	11.667
109	109	0	0	0.063	1.434	2.272	2.623	10.164	16.837	19.054	3.11	10.023
121	121	0	0	0.071	1.363	2.268	2.644	14.176	19.404	31.836	3.556	13.962
119	119	0	0	0.068	1.504	2.165	2.442	12.89	22.397	24.518	3.382	12.574
111	111	0	0	0.064	1.402	2.317	2.656	13.519	18.818	33.017	3.623	13.25
116	116	0	0	0.067	1.528	2.171	2.408	8.793	17.483	21.513	3.099	8.544
113	113	0	0	0.068	1.522	2.273	2.549	9.023	24.457	25.617	3.512	8.798
239	239	0	0	0.135	1.357	2.071	2.425	10.784	20.659	28.253	3.19	10.466
115	115	0	0	0.067	1.398	2.188	2.536	11.529	17.038	18.738	3.31	11.358
238	238	0	0	0.134	1.313	2.159	2.64	14.432	20.847	31.008	3.589	14.27
113	113	0	0	0.069	1.398	2.258	3.011	15.229	19.729	30.599	4.157	15.101
217	217	0	0	0.125	1.31	2.116	2.427	11.389	16.99	19.513	3.112	11
129	129	0	0	0.076	1.3	2.225	2.517	9.817	18.142	31.385	3.306	9.673
210	210	0	0	0.121	1.342	2.114	2.446	11.747	16.531	28.892	3.306	11.521
124	124	0	0	0.072	1.347	2.255	2.508	13.663	19.656	30.91	3.462	13.53
221	221	0	0	0.127	1.21	2.107	2.35	11.415	17.302	30.703	3.241	11.284
111	111	0	0	0.064	1.397	2.285	2.637	11.594	20.174	28.8	3.58	11.436
120	120	0	0	0.069	1.483	2.217	2.815	17.284	29.918	31.526	4.11	17.155
117	117	0	0	0.069	1.508	2.271	2.749	13.42	27.116	34.185	3.888	13.271

Expand

title	Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-12 18:29:30.957+00			PARSING_IN_PROGRESS
mob08	10k_bib_Create.mrc	2024-03-12 18:29:47.138+00			PARSING_IN_PROGRESS
mob01	10k_bib_Create.mrc	2024-03-12 18:31:30.217+00	2024-03-12 20:00:26.731+00	28:56.5	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-12 18:31:47.046+00			PARSING_IN_PROGRESS
mob02	10k_bib_Create.mrc	2024-03-12 18:33:30.531+00			PARSING_IN_PROGRESS
mob014	10k_bib_Create.mrc	2024-03-12 18:33:47.01+00	2024-03-12 19:59:12.717+00	25:25.7	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-12 18:35:30.261+00			PARSING_IN_PROGRESS
mob016	10k_bib_Create.mrc	2024-03-12 18:35:47.398+00			PARSING_IN_PROGRESS
mob04	10k_bib_Create.mrc	2024-03-12 18:37:30.349+00	2024-03-12 20:08:58.23+00	31:27.9	COMMITTED
mob018	10k_bib_Create.mrc	2024-03-12 18:37:46.953+00	2024-03-12 20:10:07.45+00	32:20.5	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-12 18:39:30.257+00	2024-03-12 18:43:27.248+00	03:57.0	ERROR
mob020	10k_bib_Create.mrc	2024-03-12 18:39:47.195+00	2024-03-12 19:39:12.202+00	59:25.0	ERROR
mob06	10k_bib_Create.mrc	2024-03-12 18:41:30.417+00			PARSING_IN_PROGRESS
mob022	10k_bib_Create.mrc	2024-03-12 18:41:46.965+00	2024-03-12 19:35:23.03+00	53:36.1	ERROR
mob07	10k_bib_Create.mrc	2024-03-12 18:43:30.294+00	2024-03-12 20:11:42.865+00	28:12.6	ERROR
mob024	10k_bib_Create.mrc	2024-03-12 18:43:47.108+00	2024-03-12 19:58:46.958+00	14:59.8	ERROR
mob09	10k_bib_Create.mrc	2024-03-12 18:45:30.381+00	2024-03-12 20:13:09.569+00	27:39.2	ERROR
mob026	10k_bib_Create.mrc	2024-03-12 18:45:47.055+00	2024-03-12 20:14:17.65+00	28:30.6	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-12 18:47:30.362+00			PARSING_IN_PROGRESS
mob028	10k_bib_Create.mrc	2024-03-12 18:47:46.92+00	2024-03-12 20:13:30.698+00	25:43.8	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-12 18:49:30.287+00	2024-03-12 20:13:51.088+00	24:20.8	COMMITTED
mob030	10k_bib_Create.mrc	2024-03-12 18:49:46.929+00	2024-03-12 19:41:24.952+00	51:38.0	ERROR
mob013	10k_bib_Create.mrc	2024-03-12 18:51:30.279+00	2024-03-12 20:13:49.265+00	22:19.0	COMMITTED
mob032	10k_bib_Create.mrc	2024-03-12 18:51:47.087+00	2024-03-12 20:13:44.873+00	21:57.8	COMMITTED
mob015	10k_bib_Create.mrc	2024-03-12 18:53:30.319+00	2024-03-12 20:14:29.614+00	20:59.3	COMMITTED
mob034	10k_bib_Create.mrc	2024-03-12 18:53:46.894+00	2024-03-12 20:14:30.311+00	20:43.4	COMMITTED
mob017	10k_bib_Create.mrc	2024-03-12 18:55:30.268+00	2024-03-12 20:14:02.733+00	18:32.5	COMMITTED
mob036	10k_bib_Create.mrc	2024-03-12 18:55:46.984+00	2024-03-12 20:14:28.876+00	18:41.9	ERROR
mob019	10k_bib_Create.mrc	2024-03-12 18:57:30.422+00			PARSING_IN_PROGRESS
mob038	10k_bib_Create.mrc	2024-03-12 18:57:47.75+00	2024-03-12 20:14:26.943+00	16:39.2	COMMITTED

Test №8

DB_MAXSHAREDPOOLSIZE=210 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	146	1.251	1.444	10.652	26.565	2.568	40	2:07:05	PARSING	ERROR
CICO_TC_Check-Out	143	2.302	2.795	18.382	32.563	4.760	7	2:07:05	2	3

Expand

title	Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_mob01	108	107	1	0.926	0.061	0.842	1.306	1.45	14.313	24.466	29.918	2.438	14.222
CICO_TC_Check-In Controller_mob011	111	111	0	0	0.065	0.836	1.301	1.445	11.735	21.629	27.314	2.609	11.583
CICO_TC_Check-In Controller_mob013	113	113	0	0	0.064	0.894	1.31	1.502	11.506	26.03	27.5	2.452	11.381
CICO_TC_Check-In Controller_mob015	121	121	0	0	0.068	0.857	1.27	1.547	13.34	30.398	40.382	2.978	13.197
CICO_TC_Check-In Controller_mob017	123	123	0	0	0.071	0.888	1.285	1.447	9.318	19.031	35.671	2.294	9.242
CICO_TC_Check-In Controller_mob019	112	112	0	0	0.063	0.88	1.218	1.383	5.181	25.327	36.116	2.271	5.055
CICO_TC_Check-In Controller_mob021	112	111	1	0.893	0.065	0.76	1.259	1.415	2.346	24.792	36.957	2.214	2.208
CICO_TC_Check-In Controller_mob023	102	102	0	0	0.061	0.885	1.22	1.342	1.714	17.651	30.358	1.937	1.638
CICO_TC_Check-In Controller_mob024	125	124	1	0.8	0.071	0.896	1.292	1.491	15.615	38.23	42.647	3.188	15.526
CICO_TC_Check-In Controller_mob025	98	98	0	0	0.055	0.863	1.234	1.441	6.142	18.624	35.284	2.245	6.027
CICO_TC_Check-In Controller_mob027	111	111	0	0	0.063	0.959	1.292	1.436	12.138	24.74	39.782	2.548	12.031
CICO_TC_Check-In Controller_mob028	115	113	2	1.739	0.067	0.87	1.281	1.502	9.142	25.511	32.646	2.605	9.07
CICO_TC_Check-In Controller_mob029	121	120	1	0.826	0.069	0.901	1.265	1.472	10.131	29.445	30.063	2.685	9.999
CICO_TC_Check-In Controller_mob03	117	116	1	0.855	0.067	0.854	1.226	1.409	8.549	24.108	25.873	2.218	8.431
CICO_TC_Check-In Controller_mob030	124	123	1	0.806	0.073	0.902	1.288	1.529	13.022	27.075	38.847	2.908	12.904
CICO_TC_Check-In Controller_mob031	110	109	1	0.909	0.063	0.929	1.272	1.48	15.002	24.746	28.897	2.835	14.88
CICO_TC_Check-In Controller_mob032	115	113	2	1.739	0.066	0.843	1.256	1.506	15.272	25.715	33.451	3.003	15.199
CICO_TC_Check-In Controller_mob033	114	114	0	0	0.065	0.869	1.206	1.392	4.528	19.249	25.907	1.929	4.433
CICO_TC_Check-In Controller_mob034	117	115	2	1.709	0.067	0.879	1.261	1.531	12.823	32.672	37.325	2.824	12.738
CICO_TC_Check-In Controller_mob035	112	111	1	0.893	0.065	0.782	1.276	1.469	15.312	28.857	35.185	3.165	15.23
CICO_TC_Check-In Controller_mob036	244	242	2	0.82	0.136	0.835	1.204	1.398	14.516	29.997	33.243	2.625	14.432
CICO_TC_Check-In Controller_mob037	120	119	1	0.833	0.07	0.937	1.27	1.473	10.548	22.429	25.388	2.306	10.441
CICO_TC_Check-In Controller_mob038	214	213	1	0.467	0.119	0.846	1.202	1.351	11.683	25.298	29.38	2.495	11.602
CICO_TC_Check-In Controller_mob039	122	122	0	0	0.073	0.854	1.258	1.439	5.373	18.702	25.393	2.073	5.238
CICO_TC_Check-In Controller_mob040	238	236	2	0.84	0.133	0.807	1.175	1.353	9.996	24.984	38.73	2.279	9.837
CICO_TC_Check-In Controller_mob041	111	110	1	0.901	0.065	0.863	1.305	1.498	10.682	26.865	29.3	2.766	10.594
CICO_TC_Check-In Controller_mob042	221	220	1	0.452	0.126	0.776	1.188	1.391	14.109	24.547	39.482	2.478	14.027
CICO_TC_Check-In Controller_mob043	107	107	0	0	0.062	0.902	1.294	1.492	15.412	25.08	29.934	2.807	15.31
CICO_TC_Check-In Controller_mob044	231	229	2	0.866	0.132	0.73	1.206	1.368	11.593	28.15	38.307	2.649	11.514
CICO_TC_Check-In Controller_mob045	110	110	0	0	0.063	0.826	1.302	1.474	14.099	30.243	39.557	2.768	14.037
CICO_TC_Check-In Controller_mob046	234	233	1	0.427	0.135	0.78	1.208	1.397	9.388	25.382	39.964	2.414	9.284
CICO_TC_Check-In Controller_mob047	111	111	0	0	0.063	0.828	1.27	1.502	5.408	28.57	34.709	2.331	5.294
CICO_TC_Check-In Controller_mob048	231	230	1	0.433	0.131	0.851	1.183	1.366	7.579	24.956	39.625	2.292	7.48
CICO_TC_Check-In Controller_mob049	115	114	1	0.87	0.066	0.927	1.299	1.424	5.063	18.287	26.453	2.108	4.97
CICO_TC_Check-In Controller_mob05	112	112	0	0	0.063	0.842	1.329	1.446	6.55	36.397	40.843	2.657	6.449
CICO_TC_Check-In Controller_mob050	230	228	2	0.87	0.128	0.809	1.155	1.344	12.264	31.676	37.908	2.611	12.168
CICO_TC_Check-In Controller_mob051	113	111	2	1.77	0.064	0.908	1.283	1.535	12.409	25.145	39.98	2.923	12.317
CICO_TC_Check-In Controller_mob052	227	226	1	0.441	0.127	0.827	1.192	1.32	10.545	38.669	41.088	2.585	10.433
CICO_TC_Check-In Controller_mob053	118	117	1	0.847	0.07	0.902	1.248	1.491	7.393	21.486	25.202	2.342	7.234
CICO_TC_Check-In Controller_mob054	240	240	0	0	0.137	0.819	1.19	1.365	9.688	27.279	39.097	2.354	9.594
CICO_TC_Check-In Controller_mob055	102	102	0	0	0.058	0.849	1.331	1.557	17.188	32.881	34.579	3.5	17.075
CICO_TC_Check-In Controller_mob056	238	237	1	0.42	0.133	0.83	1.176	1.394	11.935	25.796	26.564	2.418	11.855
CICO_TC_Check-In Controller_mob057	127	126	1	0.787	0.074	0.892	1.287	1.567	12.918	33.412	40.047	2.886	12.837
CICO_TC_Check-In Controller_mob058	238	235	3	1.261	0.133	0.804	1.167	1.313	13.842	31.523	37.623	2.598	13.76
CICO_TC_Check-In Controller_mob059	114	113	1	0.877	0.067	0.882	1.221	1.448	8.36	28.572	34.085	2.506	8.229
CICO_TC_Check-In Controller_mob060	233	233	0	0	0.131	0.784	1.197	1.414	14.089	27.534	39.382	2.826	14.002
CICO_TC_Check-In Controller_mob07	116	116	0	0	0.067	0.862	1.316	1.506	7.544	21.257	36.049	2.466	7.435
CICO_TC_Check-In Controller_mob09	115	114	1	0.87	0.065	0.911	1.291	1.479	13.991	31.694	37.273	2.834	13.902
CICO_TC_Check-Out Controller_mob01	120	120	0	0	0.07	1.593	2.439	3.995	18.993	38.345	42.393	5.653	18.852
CICO_TC_Check-Out Controller_mob011	116	116	0	0	0.066	1.832	2.377	2.769	19.478	28.879	32.994	4.838	19.339
CICO_TC_Check-Out Controller_mob013	114	114	0	0	0.066	1.808	2.421	3.141	21.472	32.047	35.026	5.412	21.29
CICO_TC_Check-Out Controller_mob015	106	106	0	0	0.063	1.717	2.382	2.785	16.621	38.719	49.961	5.049	16.474
CICO_TC_Check-Out Controller_mob017	104	104	0	0	0.059	1.71	2.443	4.569	21.76	29.599	35.269	5.375	21.653
CICO_TC_Check-Out Controller_mob019	115	115	0	0	0.066	1.567	2.361	2.785	18.337	30.686	33.744	4.905	18.156
CICO_TC_Check-Out Controller_mob021	115	115	0	0	0.065	1.662	2.37	2.771	18.851	27.744	36.154	4.829	18.668
CICO_TC_Check-Out Controller_mob023	124	124	0	0	0.07	1.651	2.373	2.861	18.476	33.739	38.107	4.778	18.374
CICO_TC_Check-Out Controller_mob024	103	103	0	0	0.057	1.781	2.341	2.983	16.867	34.488	38.555	5.097	16.741
CICO_TC_Check-Out Controller_mob025	130	130	0	0	0.077	1.679	2.308	2.672	17.42	32.301	38.565	4.437	17.284
CICO_TC_Check-Out Controller_mob027	116	116	0	0	0.068	1.615	2.345	2.751	20.447	36.362	43.593	5.037	20.287
CICO_TC_Check-Out Controller_mob028	114	114	0	0	0.064	1.775	2.317	2.829	16.437	33.925	34.775	4.728	16.267
CICO_TC_Check-Out Controller_mob029	105	104	1	0.952	0.061	1.776	2.364	2.737	22.834	34.576	36.185	5.091	22.687
CICO_TC_Check-Out Controller_mob03	111	111	0	0	0.063	1.67	2.373	2.719	17.322	34.593	36.845	5.275	17.207
CICO_TC_Check-Out Controller_mob030	104	104	0	0	0.058	1.743	2.463	2.897	15.239	23.262	23.909	4.415	15.103
CICO_TC_Check-Out Controller_mob031	116	115	1	0.862	0.068	1.792	2.326	2.61	18.171	33.656	34.647	4.345	18.021
CICO_TC_Check-Out Controller_mob032	113	113	0	0	0.063	1.628	2.328	2.737	17.102	41.184	42.34	4.87	16.999
CICO_TC_Check-Out Controller_mob033	113	113	0	0	0.065	1.707	2.316	2.753	20.141	27.154	33.283	4.818	20.004
CICO_TC_Check-Out Controller_mob034	110	110	0	0	0.062	1.615	2.356	2.818	15.611	32.629	42.053	4.169	15.501
CICO_TC_Check-Out Controller_mob035	115	114	1	0.87	0.066	1.797	2.296	2.59	17.017	31.496	34.957	4.528	16.903
CICO_TC_Check-Out Controller_mob036	210	210	0	0	0.119	1.635	2.212	2.474	17.223	33.305	41.164	4.283	17.07
CICO_TC_Check-Out Controller_mob037	107	107	0	0	0.061	1.699	2.352	2.896	20.209	32.847	34.675	5.071	20.087
CICO_TC_Check-Out Controller_mob038	242	242	0	0	0.14	1.603	2.155	2.416	14.323	33.78	37.564	4.261	14.223
CICO_TC_Check-Out Controller_mob039	106	106	0	0	0.061	1.669	2.349	2.681	21.294	26.244	28.695	4.449	21.173
CICO_TC_Check-Out Controller_mob040	217	217	0	0	0.125	1.636	2.212	2.65	17.859	34.496	37.378	4.722	17.745
CICO_TC_Check-Out Controller_mob041	117	117	0	0	0.067	1.54	2.282	2.664	16.605	27.26	29.992	4.462	16.457
CICO_TC_Check-Out Controller_mob042	232	232	0	0	0.13	1.62	2.208	2.656	20.693	32.989	35.494	4.739	20.564
CICO_TC_Check-Out Controller_mob043	119	119	0	0	0.068	1.718	2.269	2.623	20.403	30.026	34.625	4.681	20.215
CICO_TC_Check-Out Controller_mob044	222	222	0	0	0.124	1.553	2.197	2.581	16.481	33.325	37.195	4.398	16.342
CICO_TC_Check-Out Controller_mob045	117	117	0	0	0.071	1.739	2.355	2.809	21.233	36.442	44.189	5.538	21.078
CICO_TC_Check-Out Controller_mob046	221	221	0	0	0.124	1.597	2.131	2.521	17.465	36.472	42.152	4.605	17.302
CICO_TC_Check-Out Controller_mob047	116	116	0	0	0.07	1.696	2.341	2.779	18.806	33.12	34.235	4.978	18.696
CICO_TC_Check-Out Controller_mob048	225	225	0	0	0.126	1.571	2.212	2.758	18.16	32.344	33.328	4.71	18.05
CICO_TC_Check-Out Controller_mob049	112	112	0	0	0.064	1.59	2.366	3.915	18.52	26.989	34.289	5.294	18.385
CICO_TC_Check-Out Controller_mob05	117	117	0	0	0.07	1.777	2.423	2.856	17.792	30.359	31.972	4.596	17.641
CICO_TC_Check-Out Controller_mob050	224	223	1	0.446	0.131	1.575	2.124	2.451	17.424	35.143	42.764	4.159	17.253
CICO_TC_Check-Out Controller_mob051	114	114	0	0	0.066	1.774	2.311	2.658	16.535	28.792	42.849	4.503	16.411
CICO_TC_Check-Out Controller_mob052	227	226	1	0.441	0.131	1.685	2.155	2.469	17.776	26.015	36.286	4.469	17.607
CICO_TC_Check-Out Controller_mob053	109	108	1	0.917	0.062	1.538	2.332	2.97	21.56	37.238	48.643	5.642	21.42
CICO_TC_Check-Out Controller_mob054	215	215	0	0	0.121	1.616	2.215	2.67	16.666	35.175	38.158	4.451	16.522
CICO_TC_Check-Out Controller_mob055	125	124	1	0.8	0.073	1.519	2.273	2.859	22.71	40.258	42.121	5.562	22.575
CICO_TC_Check-Out Controller_mob056	218	218	0	0	0.126	1.547	2.179	2.473	17.95	32.773	34.101	4.538	17.83
CICO_TC_Check-Out Controller_mob057	99	99	0	0	0.057	1.689	2.313	2.593	16.943	34.136	35.853	4.137	16.814
CICO_TC_Check-Out Controller_mob058	216	216	0	0	0.124	1.682	2.135	2.498	17.903	33.878	37.537	4.611	17.758
CICO_TC_Check-Out Controller_mob059	111	111	0	0	0.065	1.664	2.287	2.537	17.639	26.988	27.437	4.176	17.524
CICO_TC_Check-Out Controller_mob060	220	220	0	0	0.126	1.553	2.156	2.575	16.865	27.046	44.952	4.264	16.748
CICO_TC_Check-Out Controller_mob07	113	113	0	0	0.064	1.89	2.341	2.78	17.811	34.883	38.588	4.63	17.687
CICO_TC_Check-Out Controller_mob09	111	110	1	0.901	0.066	1.81	2.317	2.588	18.903	35.295	37.878	4.913	18.692

Expand

title	Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-13 17:53:06.169+00	2024-03-13 19:25:17.349+00	32:11.2	COMMITTED
mob024	10k_bib_Create.mrc	2024-03-13 17:53:41.965+00	2024-03-13 19:46:02.299+00	52:20.3	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-13 17:55:05.7+00	2024-03-13 19:52:43.748+00	57:38.0	COMMITTED
mob028	10k_bib_Create.mrc	2024-03-13 17:55:41.811+00	2024-03-13 19:46:06.566+00	50:24.8	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-13 17:57:05.701+00	2024-03-13 19:55:24.617+00	58:18.9	COMMITTED
mob030	10k_bib_Create.mrc	2024-03-13 17:57:41.935+00	2024-03-13 19:48:22.924+00	50:41.0	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-13 17:59:05.207+00	2024-03-13 19:56:27.568+00	57:22.4	COMMITTED
mob032	10k_bib_Create.mrc	2024-03-13 17:59:41.856+00	2024-03-13 19:54:29.564+00	54:47.7	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-13 18:01:05.406+00	2024-03-13 18:16:57.685+00	15:52.3	ERROR
mob034	10k_bib_Create.mrc	2024-03-13 18:01:41.754+00	2024-03-13 19:59:06.644+00	57:24.9	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-13 18:03:05.319+00	2024-03-13 19:58:33.715+00	55:28.4	COMMITTED
mob036	10k_bib_Create.mrc	2024-03-13 18:03:41.787+00			PARSING_IN_PROGRESS
mob06	10k_bib_Create.mrc	2024-03-13 18:05:05.28+00	2024-03-13 19:53:49.771+00	48:44.5	COMMITTED
mob038	10k_bib_Create.mrc	2024-03-13 18:05:41.742+00	2024-03-13 19:59:13.742+00	1:53:32	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-13 18:07:04.985+00	2024-03-13 19:59:53.324+00	52:48.3	COMMITTED
mob040	10k_bib_Create.mrc	2024-03-13 18:07:41.747+00	2024-03-13 19:59:46.375+00	52:04.6	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-13 18:09:05.487+00	2024-03-13 20:00:09.34+00	51:03.9	COMMITTED
mob042	10k_bib_Create.mrc	2024-03-13 18:09:41.788+00	2024-03-13 19:58:28.944+00	48:47.2	ERROR
mob09	10k_bib_Create.mrc	2024-03-13 18:11:04.97+00	2024-03-13 20:00:19.943+00	49:15.0	COMMITTED
mob044	10k_bib_Create.mrc	2024-03-13 18:11:41.786+00	2024-03-13 19:59:41.842+00	48:00.1	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-13 18:13:05.518+00	2024-03-13 19:59:46.676+00	46:41.2	COMMITTED
mob046	10k_bib_Create.mrc	2024-03-13 18:13:41.719+00	2024-03-13 20:00:07.012+00	46:25.3	ERROR
mob011	10k_bib_Create.mrc	2024-03-13 18:15:04.959+00			PARSING_IN_PROGRESS
mob048	10k_bib_Create.mrc	2024-03-13 18:15:46.582+00	2024-03-13 20:00:12.714+00	44:26.1	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-13 18:17:05.341+00	2024-03-13 20:00:13.901+00	43:08.6	COMMITTED
mob050	10k_bib_Create.mrc	2024-03-13 18:17:43.146+00	2024-03-13 20:00:05.371+00	42:22.2	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-13 18:19:05.006+00	2024-03-13 20:00:03.235+00	40:58.2	COMMITTED
mob052	10k_bib_Create.mrc	2024-03-13 18:19:53.569+00	2024-03-13 20:00:17.81+00	40:24.2	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-13 18:21:05.348+00	2024-03-13 20:00:19.725+00	39:14.4	COMMITTED
mob054	10k_bib_Create.mrc	2024-03-13 18:21:41.689+00	2024-03-13 20:00:11.693+00	38:30.0	COMMITTED

Test №9

DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage plus DB_MAXSHAREDPOOLSIZE=70 parameter for others modules

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	94	1.15	1.35	48.75	82.41	7.33	0	1:46:43	PARSING	ERROR
CICO_TC_Check-Out	94	2.18	12.34	66.22	103.74	14.43	1	1:46:43	4	4

Expand

title	Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	91	91	0	0	0.052	0.866	1.483	1.822	43.553	80.528	97.128	6.398	43.451
CICO_TC_Check-In Controller_mob01	99	99	0	0	0.057	0.774	1.135	1.347	49.584	77.934	98.945	6.159	49.481
CICO_TC_Check-In Controller_mob010	88	88	0	0	0.051	0.758	1.161	1.327	43.459	69.67	102.523	6.478	43.392
CICO_TC_Check-In Controller_mob011	90	90	0	0	0.05	0.832	1.165	1.416	51.735	76.271	110.225	7.175	51.644
CICO_TC_Check-In Controller_mob012	90	90	0	0	0.057	0.763	1.169	1.355	47.079	56.168	63.626	5.707	46.981
CICO_TC_Check-In Controller_mob013	91	91	0	0	0.053	0.835	1.193	1.459	50.447	109.062	113.585	9.399	50.342
CICO_TC_Check-In Controller_mob014	91	91	0	0	0.053	0.784	1.175	1.345	51.093	70.351	100.63	7.571	50.996
CICO_TC_Check-In Controller_mob015	98	98	0	0	0.055	0.743	1.126	1.351	56.576	104.794	107.844	8.789	56.464
CICO_TC_Check-In Controller_mob016	93	93	0	0	0.053	0.877	1.137	1.363	54.463	72.039	96.926	8.875	54.353
CICO_TC_Check-In Controller_mob017	96	96	0	0	0.054	0.845	1.135	1.449	49.952	100.681	109.314	7.716	49.858
CICO_TC_Check-In Controller_mob018	94	94	0	0	0.053	0.856	1.136	1.29	49.309	76.711	101.143	7.07	49.234
CICO_TC_Check-In Controller_mob019	98	98	0	0	0.055	0.791	1.176	1.331	50.039	102.326	109.247	6.909	49.947
CICO_TC_Check-In Controller_mob02	88	88	0	0	0.049	0.743	1.19	1.541	56.141	65.09	114.061	9.397	55.974
CICO_TC_Check-In Controller_mob020	98	98	0	0	0.056	0.855	1.147	1.356	46.009	57.753	92.57	7.264	45.938
CICO_TC_Check-In Controller_mob021	99	99	0	0	0.06	0.779	1.151	1.273	31.458	64.914	68.905	4.71	31.374
CICO_TC_Check-In Controller_mob022	80	80	0	0	0.045	0.806	1.175	1.345	40.553	106.055	114.907	7.517	40.449
CICO_TC_Check-In Controller_mob023	86	86	0	0	0.05	0.75	1.147	1.308	60.152	74.814	102.713	7.445	60.059
CICO_TC_Check-In Controller_mob024	102	102	0	0	0.058	0.752	1.115	1.302	58.405	77.764	101.88	8.269	58.33
CICO_TC_Check-In Controller_mob025	102	102	0	0	0.058	0.791	1.133	1.401	60.345	94.124	104.129	9.916	60.255
CICO_TC_Check-In Controller_mob026	87	87	0	0	0.052	0.816	1.146	1.305	44.05	70.201	105.574	5.917	43.972
CICO_TC_Check-In Controller_mob027	97	97	0	0	0.058	0.786	1.139	1.276	51.407	67.794	108.914	7.135	51.334
CICO_TC_Check-In Controller_mob028	92	92	0	0	0.052	0.75	1.156	1.354	47.651	104.758	110.514	7.86	47.56
CICO_TC_Check-In Controller_mob029	101	101	0	0	0.064	0.792	1.112	1.265	34.416	57.4	77.789	5.134	34.336
CICO_TC_Check-In Controller_mob03	99	99	0	0	0.055	0.832	1.139	1.325	50.446	75.364	103.96	6.961	50.349
CICO_TC_Check-In Controller_mob030	93	93	0	0	0.058	0.815	1.169	1.289	29.228	58.625	64.855	4.803	29.139
CICO_TC_Check-In Controller_mob031	84	84	0	0	0.052	0.798	1.115	1.306	33.229	63.515	75.619	5.205	33.131
CICO_TC_Check-In Controller_mob032	86	86	0	0	0.05	0.784	1.143	1.354	40.477	105.459	109.787	7.251	40.403
CICO_TC_Check-In Controller_mob033	95	95	0	0	0.054	0.763	1.164	1.39	56.936	102.884	104.937	7.838	56.848
CICO_TC_Check-In Controller_mob034	103	103	0	0	0.06	0.846	1.181	1.467	41.357	71.89	101.154	7.212	41.284
CICO_TC_Check-In Controller_mob035	97	97	0	0	0.056	0.751	1.135	1.297	49.307	72.178	101.844	7.014	49.174
CICO_TC_Check-In Controller_mob036	109	109	0	0	0.062	0.8	1.14	1.381	33.426	101.246	109.13	5.442	33.351
CICO_TC_Check-In Controller_mob037	83	83	0	0	0.048	0.848	1.103	1.21	47.141	108.457	117.113	6.403	47.008
CICO_TC_Check-In Controller_mob038	98	98	0	0	0.056	0.752	1.129	1.313	43.389	98.488	111.705	7.157	43.286
CICO_TC_Check-In Controller_mob039	81	81	0	0	0.046	0.804	1.136	1.415	53.931	58.675	117.954	8.559	53.84
CICO_TC_Check-In Controller_mob04	101	101	0	0	0.059	0.781	1.185	1.398	38.477	54.931	108.747	6.611	38.397
CICO_TC_Check-In Controller_mob040	89	89	0	0	0.052	0.804	1.129	1.339	59.011	101.067	109.718	8.688	58.884
CICO_TC_Check-In Controller_mob041	92	92	0	0	0.054	0.821	1.138	1.361	56.278	82.948	91.682	8.581	56.177
CICO_TC_Check-In Controller_mob042	91	91	0	0	0.053	0.812	1.168	1.333	43.895	60.412	96.218	7.002	43.806
CICO_TC_Check-In Controller_mob043	88	88	0	0	0.052	0.815	1.103	1.352	56.648	96.393	118.336	8.399	56.546
CICO_TC_Check-In Controller_mob044	100	100	0	0	0.057	0.803	1.082	1.244	44.611	95.473	99.405	6.587	44.522
CICO_TC_Check-In Controller_mob045	95	95	0	0	0.054	0.834	1.112	1.276	59.815	101.146	119.316	8.011	59.717
CICO_TC_Check-In Controller_mob046	99	99	0	0	0.057	0.807	1.117	1.256	63.638	93.283	95.213	8.73	63.508
CICO_TC_Check-In Controller_mob047	100	100	0	0	0.058	0.803	1.121	1.269	52.369	67.161	109.405	7.492	52.272
CICO_TC_Check-In Controller_mob048	102	102	0	0	0.058	0.739	1.086	1.199	60.717	102.274	109.761	7.34	60.608
CICO_TC_Check-In Controller_mob049	93	93	0	0	0.053	0.89	1.118	1.263	41.02	76.911	89.362	7.095	40.923
CICO_TC_Check-In Controller_mob05	99	99	0	0	0.055	0.739	1.199	1.417	46.224	79.49	107.372	6.889	46.142
CICO_TC_Check-In Controller_mob050	84	84	0	0	0.048	0.824	1.149	1.381	60.604	86.997	114.845	8.696	60.521
CICO_TC_Check-In Controller_mob051	94	94	0	0	0.054	0.814	1.123	1.331	49.458	103.423	111.774	7.436	49.355
CICO_TC_Check-In Controller_mob052	94	94	0	0	0.054	0.832	1.107	1.283	39.637	60.963	103.93	5.929	39.561
CICO_TC_Check-In Controller_mob053	80	80	0	0	0.046	0.812	1.113	1.357	62.663	103.182	112.129	8.5	62.566
CICO_TC_Check-In Controller_mob054	98	98	0	0	0.056	0.793	1.111	1.34	54.804	79.036	101.896	7.949	54.705
CICO_TC_Check-In Controller_mob055	96	96	0	0	0.055	0.815	1.123	1.306	60.716	107.126	109.857	7.854	60.597
CICO_TC_Check-In Controller_mob056	89	89	0	0	0.052	0.784	1.125	1.329	52.774	80.223	113.273	8.837	52.679
CICO_TC_Check-In Controller_mob057	107	107	0	0	0.064	0.821	1.16	1.447	53.057	64.648	97.692	7.683	52.965
CICO_TC_Check-In Controller_mob058	99	99	0	0	0.062	0.77	1.141	1.273	38.519	59.375	69.978	5.719	38.446
CICO_TC_Check-In Controller_mob059	93	93	0	0	0.053	0.728	1.123	1.348	34.19	55.942	110.482	5.552	34.119
CICO_TC_Check-In Controller_mob06	101	101	0	0	0.06	0.745	1.156	1.356	48.953	101.423	117.005	6.956	48.845
CICO_TC_Check-In Controller_mob060	81	81	0	0	0.047	0.834	1.106	1.247	36.724	65.486	110.203	6.689	36.649
CICO_TC_Check-In Controller_mob07	93	93	0	0	0.052	0.768	1.154	1.33	63.73	103.606	110.974	9.523	63.647
CICO_TC_Check-In Controller_mob08	97	0	97	100	0	0.802	1.158	1.434	63.299	96.695	108.29	10.376	63.168
CICO_TC_Check-In Controller_mob09	97	97	0	0	0.059	0.876	1.186	1.31	25.468	93.611	95.031	5.171	25.372
CICO_TC_Check-Out Controller_fs00001137	97	96	1	1.031	0.054	1.91	3.115	19.454	62.482	107.238	129.18	16.286	62.312
CICO_TC_Check-Out Controller_mob01	88	88	0	0	0.049	1.575	2.22	9.112	66.903	112.9	113.681	15.191	66.756
CICO_TC_Check-Out Controller_mob010	101	101	0	0	0.056	1.633	2.272	28.844	82.398	113.273	117.208	17.594	82.264
CICO_TC_Check-Out Controller_mob011	98	98	0	0	0.058	1.469	2.17	3.437	63.115	111.783	120.177	14.463	62.988
CICO_TC_Check-Out Controller_mob012	99	99	0	0	0.055	1.55	2.345	29.075	94.577	118.838	121.927	19.869	94.48
CICO_TC_Check-Out Controller_mob013	98	98	0	0	0.055	1.567	2.282	3.806	62.381	120.062	120.301	13.179	62.277
CICO_TC_Check-Out Controller_mob014	98	98	0	0	0.055	1.631	2.341	26.856	59.455	110.692	120.399	15.726	59.32
CICO_TC_Check-Out Controller_mob015	91	91	0	0	0.052	1.469	2.103	3.547	61.847	82.478	105.566	13.291	61.718
CICO_TC_Check-Out Controller_mob016	96	96	0	0	0.057	1.471	2.179	12.01	70.989	107.177	108.181	14.128	70.84
CICO_TC_Check-Out Controller_mob017	93	93	0	0	0.053	1.508	2.174	3.992	58.948	106.773	118.841	12.708	58.826
CICO_TC_Check-Out Controller_mob018	94	94	0	0	0.055	1.565	2.169	20.897	64.484	111.967	118.5	14.935	64.352
CICO_TC_Check-Out Controller_mob019	89	89	0	0	0.052	1.552	2.227	18.678	66.375	69.423	110.999	14.611	66.223
CICO_TC_Check-Out Controller_mob02	99	99	0	0	0.057	1.55	2.125	2.449	57.217	105.035	105.416	9.94	57.097
CICO_TC_Check-Out Controller_mob020	91	91	0	0	0.053	1.551	2.269	8.062	68.931	111.684	111.908	15.703	68.796
CICO_TC_Check-Out Controller_mob021	90	90	0	0	0.053	1.51	2.18	20.804	74.462	109.741	111.076	16.2	74.296
CICO_TC_Check-Out Controller_mob022	107	107	0	0	0.062	1.528	2.138	16.638	61.888	111.389	113.356	13.906	61.58
CICO_TC_Check-Out Controller_mob023	103	103	0	0	0.058	1.566	2.19	17.897	72.122	120.188	124.708	15.803	71.971
CICO_TC_Check-Out Controller_mob024	86	86	0	0	0.052	1.65	2.164	3.071	56.693	104.241	116.64	12.077	56.587
CICO_TC_Check-Out Controller_mob025	86	86	0	0	0.053	1.445	2.115	2.634	54.445	65.676	67.183	10.543	54.311
CICO_TC_Check-Out Controller_mob026	102	102	0	0	0.057	1.56	2.207	22.523	62.595	99.531	111.466	15.066	62.428
CICO_TC_Check-Out Controller_mob027	90	90	0	0	0.051	1.429	2.196	18.01	70.816	110.202	122.748	15.106	70.617
CICO_TC_Check-Out Controller_mob028	96	96	0	0	0.059	1.628	2.164	5.415	59.787	101.978	117.512	13.49	59.656
CICO_TC_Check-Out Controller_mob029	85	85	0	0	0.048	1.579	2.156	19.195	61.306	109.913	112.557	14.016	61.163
CICO_TC_Check-Out Controller_mob03	90	90	0	0	0.052	1.546	2.135	12.861	76.509	105.133	113.07	15.688	76.335
CICO_TC_Check-Out Controller_mob030	95	95	0	0	0.054	1.489	2.133	24.586	61.109	105.032	111.024	16.319	60.964
CICO_TC_Check-Out Controller_mob031	104	104	0	0	0.059	1.485	2.218	15.074	70.76	107.299	119.224	15.354	70.616
CICO_TC_Check-Out Controller_mob032	102	102	0	0	0.058	1.493	2.163	17.187	65.396	100.064	114.668	14.847	65.279
CICO_TC_Check-Out Controller_mob033	93	93	0	0	0.054	1.458	2.203	7.654	78.714	110.925	117.448	15.944	78.557
CICO_TC_Check-Out Controller_mob034	86	86	0	0	0.049	1.535	2.176	5.629	69.891	109.887	112.148	15.81	69.756
CICO_TC_Check-Out Controller_mob035	91	91	0	0	0.054	1.468	2.18	14.852	60.723	97.86	111.996	15.032	60.582
CICO_TC_Check-Out Controller_mob036	79	79	0	0	0.046	1.577	2.194	23.753	65.989	91.353	111.255	16.184	65.817
CICO_TC_Check-Out Controller_mob037	105	105	0	0	0.06	1.6	2.074	4.743	57.03	95.702	115.948	12.252	56.9
CICO_TC_Check-Out Controller_mob038	90	90	0	0	0.052	1.641	2.112	5.363	64.469	103.831	109.368	14.178	64.361
CICO_TC_Check-Out Controller_mob039	106	106	0	0	0.061	1.575	2.099	5.829	63.643	116.734	128.332	13.881	63.474
CICO_TC_Check-Out Controller_mob04	88	88	0	0	0.049	1.625	2.184	18.845	88.38	116.048	120.448	17.428	88.284
CICO_TC_Check-Out Controller_mob040	99	99	0	0	0.056	1.44	2.054	15.684	62.709	109.327	117.732	14.649	62.564
CICO_TC_Check-Out Controller_mob041	96	96	0	0	0.054	1.622	2.067	2.493	60.951	112.361	126.657	12.503	60.756
CICO_TC_Check-Out Controller_mob042	97	97	0	0	0.055	1.568	2.083	3.341	66.74	120.423	127.637	13.934	66.596
CICO_TC_Check-Out Controller_mob043	99	99	0	0	0.057	1.473	2.132	4.37	58.736	78.073	118.637	12.45	58.615
CICO_TC_Check-Out Controller_mob044	88	88	0	0	0.051	1.526	2.24	30.442	74.548	106.438	111.706	18.231	74.407
CICO_TC_Check-Out Controller_mob045	92	92	0	0	0.054	1.578	2.096	3.11	55.65	69.816	120.449	12.144	55.485
CICO_TC_Check-Out Controller_mob046	88	88	0	0	0.052	1.651	2.062	3.021	62.243	109.871	126.096	11.409	62.108
CICO_TC_Check-Out Controller_mob047	88	88	0	0	0.05	1.54	2.132	13.023	89.28	112.255	121.006	17.021	89.186
CICO_TC_Check-Out Controller_mob048	85	85	0	0	0.049	1.546	2.329	24.855	72.921	103.104	121.154	17.411	72.795
CICO_TC_Check-Out Controller_mob049	95	95	0	0	0.055	1.493	2.135	5.096	62.771	110.253	120.784	13.562	62.644
CICO_TC_Check-Out Controller_mob05	90	90	0	0	0.052	1.579	2.196	6.375	63.691	112.223	118.313	13.602	63.538
CICO_TC_Check-Out Controller_mob050	104	104	0	0	0.06	1.584	2.066	4.233	61.197	106.328	119.114	12.498	61.044
CICO_TC_Check-Out Controller_mob051	94	94	0	0	0.054	1.524	2.131	11.445	70.597	113.292	120.346	16.104	70.438
CICO_TC_Check-Out Controller_mob052	94	94	0	0	0.054	1.483	2.163	15.471	56.128	98.264	111.528	13.691	56.011
CICO_TC_Check-Out Controller_mob053	108	108	0	0	0.063	1.57	2.115	15.628	72.028	112.735	125.677	15.137	71.87
CICO_TC_Check-Out Controller_mob054	90	90	0	0	0.053	1.688	2.12	26.467	98.939	115.827	120.628	17.587	98.847
CICO_TC_Check-Out Controller_mob055	92	92	0	0	0.056	1.541	2.118	3.331	55.447	66.581	69.153	10.233	55.34
CICO_TC_Check-Out Controller_mob056	98	98	0	0	0.056	1.646	2.119	7.736	63.133	110.413	111.274	14.081	62.994
CICO_TC_Check-Out Controller_mob057	81	81	0	0	0.046	1.607	2.206	20.77	74.639	112.942	116.993	15.736	74.486
CICO_TC_Check-Out Controller_mob058	88	88	0	0	0.05	1.503	2.075	3.906	58.52	101.125	115.672	12.823	58.398
CICO_TC_Check-Out Controller_mob059	95	95	0	0	0.059	1.628	2.175	5.18	59.65	92.229	103.56	12.971	59.497
CICO_TC_Check-Out Controller_mob06	87	87	0	0	0.048	1.727	2.208	4.107	54.245	67.528	94.892	10.648	54.139
CICO_TC_Check-Out Controller_mob060	107	107	0	0	0.061	1.564	2.119	18.468	65.085	94.068	108.953	14.46	64.918
CICO_TC_Check-Out Controller_mob07	96	96	0	0	0.057	1.468	2.199	3.759	61.401	113.5	124.495	12.077	61.249
CICO_TC_Check-Out Controller_mob08	92	92	0	0	0.052	1.65	2.283	4.223	59.479	102.332	105.279	12.877	59.354
CICO_TC_Check-Out Controller_mob09	92	92	0	0	0.051	1.484	2.236	23.717	61.924	94.587	107.995	15.803	61.756

Expand

title	Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-14 10:53:28.205+00	2024-03-14 11:02:14.227+00	08:46.0	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-14 10:55:27.423+00	2024-03-14 11:21:27.403+00	26:00.0	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-14 10:57:27.371+00	2024-03-14 11:38:10.974+00	40:43.6	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-14 10:59:27.158+00			PARSING_IN_PROGRESS
mob04	10k_bib_Create.mrc	2024-03-14 11:01:27.285+00	2024-03-14 11:50:44.487+00	49:17.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-14 11:03:27.203+00	2024-03-14 11:56:39.085+00	53:11.9	COMMITTED
fs00001137	10k_bib_Create.mrc	2024-03-14 11:04:01.491+00	2024-03-14 12:03:05.429+00	59:03.9	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-14 11:05:27.241+00	2024-03-14 12:02:16.407+00	56:49.2	ERROR
mob01	10k_bib_Create.mrc	2024-03-14 11:06:00.776+00	2024-03-14 12:11:34.747+00	05:34.0	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-14 11:07:27.209+00	2024-03-14 12:04:56.209+00	0:57:29	ERROR
mob02	10k_bib_Create.mrc	2024-03-14 11:08:00.802+00	2024-03-14 12:23:19.626+00	15:18.8	ERROR
mob08	10k_bib_Create.mrc	2024-03-14 11:09:27.456+00			PARSING_IN_PROGRESS
mob03	10k_bib_Create.mrc	2024-03-14 11:10:00.759+00	2024-03-14 12:29:10.938+00	19:10.2	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-14 11:11:27.268+00	2024-03-14 12:08:31.318+00	57:04.0	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-14 11:12:00.763+00	2024-03-14 12:33:08.591+00	21:07.8	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-14 11:13:27.333+00			PARSING_IN_PROGRESS
mob05	10k_bib_Create.mrc	2024-03-14 11:14:00.713+00	2024-03-14 12:36:38.459+00	22:37.7	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-14 11:15:27.371+00	2024-03-14 12:12:05.86+00	56:38.5	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-14 11:16:00.736+00	2024-03-14 12:39:05.198+00	23:04.5	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-14 11:17:27.438+00	2024-03-14 12:13:35.069+00	56:07.6	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-14 11:18:00.731+00	2024-03-14 12:39:21.499+00	21:20.8	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-14 11:19:27.368+00			PARSING_IN_PROGRESS
mob08	10k_bib_Create.mrc	2024-03-14 11:20:00.76+00	2024-03-14 12:34:51.074+00	14:50.3	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-14 11:21:27.215+00	2024-03-14 12:15:40.416+00	54:13.2	ERROR
mob09	10k_bib_Create.mrc	2024-03-14 11:22:00.902+00	2024-03-14 12:39:50.84+00	17:49.9	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-14 11:24:00.683+00	2024-03-14 12:39:58.045+00	15:57.4	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-14 11:26:00.691+00	2024-03-14 12:40:03.188+00	14:02.5	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-14 11:28:00.728+00	2024-03-14 12:40:08.796+00	12:08.1	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-14 11:30:00.788+00	2024-03-14 12:36:15.527+00	06:14.7	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-14 11:32:00.812+00	2024-03-14 12:40:11.43+00	08:10.6	COMMITTED

Test №10

DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage plus DB_MAXSHAREDPOOLSIZE=140 parameter for others modules.

For this test we

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	174	1.26	1.47	4.69	12.12	1.76	0	1:51:41	PARSING	ERROR
CICO_TC_Check-Out	175	2.20	2.55	8.67	14.58	3.06	0	1:51:41	1	2

Expand

title	Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-Out Controller_mob08	241	241	0	0	0.134	1.616	2.204	2.497	8.832	14.04	18.063	2.952	8.683
CICO_TC_Check-Out Controller_mob07	133	133	0	0	0.077	1.569	2.231	2.668	9.388	19.231	19.778	3.404	9.281
CICO_TC_Check-Out Controller_mob06	241	241	0	0	0.134	1.472	2.126	2.459	9.895	16.458	19.101	3.228	9.733
CICO_TC_Check-Out Controller_mob059	114	114	0	0	0.068	1.786	2.244	2.634	8.908	13.632	18.44	3.083	8.776
CICO_TC_Check-Out Controller_mob057	109	109	0	0	0.063	1.632	2.269	2.601	6.767	13.439	14.457	2.971	6.662
CICO_TC_Check-Out Controller_mob055	119	119	0	0	0.07	1.67	2.205	2.425	8.145	15.925	18.23	3.063	8.036
CICO_TC_Check-Out Controller_mob053	107	107	0	0	0.061	1.667	2.23	2.648	9.795	12.564	13.667	3.162	9.646
CICO_TC_Check-Out Controller_mob051	126	126	0	0	0.071	1.567	2.212	2.481	7.086	12.544	18.887	2.831	6.947
CICO_TC_Check-Out Controller_mob050	119	119	0	0	0.068	1.593	2.274	2.563	8.691	14.023	15.766	3.036	8.496
CICO_TC_Check-Out Controller_mob05	105	105	0	0	0.058	1.644	2.395	2.768	10.559	17.117	32.092	3.601	10.38
CICO_TC_Check-Out Controller_mob048	234	234	0	0	0.136	1.446	2.061	2.301	7.566	14.085	19.583	2.769	7.397
CICO_TC_Check-Out Controller_mob046	221	221	0	0	0.125	1.363	2.087	2.451	7.43	11.282	15.631	2.767	7.296
CICO_TC_Check-Out Controller_mob044	225	225	0	0	0.128	1.445	2.14	2.527	9.09	13.892	19.451	3.058	8.969
CICO_TC_Check-Out Controller_mob042	252	252	0	0	0.142	1.436	2.078	2.415	7.924	12.383	19.397	2.898	7.803
CICO_TC_Check-Out Controller_mob040	226	226	0	0	0.13	1.574	2.111	2.421	7.98	10.97	19.444	2.81	7.795
CICO_TC_Check-Out Controller_mob04	236	236	0	0	0.136	1.551	2.124	2.442	6.831	12.794	15.985	2.724	6.707
CICO_TC_Check-Out Controller_mob038	225	225	0	0	0.13	1.577	2.073	2.429	8.436	15.316	17.849	2.915	8.304
CICO_TC_Check-Out Controller_mob036	232	232	0	0	0.131	1.567	2.111	2.394	7.863	13.895	14.996	2.817	7.721
CICO_TC_Check-Out Controller_mob034	243	243	0	0	0.139	1.469	2.051	2.395	7.143	16.088	17.702	2.711	7.048
CICO_TC_Check-Out Controller_mob032	225	225	0	0	0.126	1.554	2.097	2.354	7.504	10.963	14.083	2.704	7.387
CICO_TC_Check-Out Controller_mob030	232	232	0	0	0.133	1.502	2.121	2.433	7.332	11.662	13.933	2.783	7.161
CICO_TC_Check-Out Controller_mob03	123	123	0	0	0.068	1.715	2.285	2.726	8.057	14.665	16.205	3.075	7.901
CICO_TC_Check-Out Controller_mob028	253	253	0	0	0.142	1.477	2.083	2.369	7.066	11.112	16.921	2.739	6.932
CICO_TC_Check-Out Controller_mob026	241	241	0	0	0.135	1.531	2.085	2.44	8.37	12.29	14.089	2.772	8.254
CICO_TC_Check-Out Controller_mob025	120	120	0	0	0.07	1.519	2.22	2.664	7.286	12.178	20.525	3.042	7.169
CICO_TC_Check-Out Controller_mob024	105	105	0	0	0.06	1.596	2.266	2.546	5.502	14.599	17.697	2.794	5.402
CICO_TC_Check-Out Controller_mob022	254	254	0	0	0.15	1.518	2.056	2.329	6.44	10.459	14.823	2.662	6.33
CICO_TC_Check-Out Controller_mob020	237	237	0	0	0.133	1.439	2.077	2.347	7.057	11.958	16.951	2.734	6.941
CICO_TC_Check-Out Controller_mob02	250	250	0	0	0.139	1.608	2.176	2.59	8.482	15.565	23.155	2.999	8.373
CICO_TC_Check-Out Controller_mob019	108	108	0	0	0.066	1.647	2.252	2.633	9.129	16.634	20.346	3.199	9.01
CICO_TC_Check-Out Controller_mob018	109	109	0	0	0.064	1.591	2.183	2.636	10.223	12.355	18.588	3.171	10.125
CICO_TC_Check-Out Controller_mob017	126	126	0	0	0.072	1.59	2.247	2.61	9.636	14.569	18.481	3.261	9.494
CICO_TC_Check-Out Controller_mob016	111	111	0	0	0.066	1.666	2.182	2.624	9.43	15.95	18.127	3.294	9.279
CICO_TC_Check-Out Controller_mob015	116	116	0	0	0.069	1.656	2.224	2.589	10.588	16.039	17.162	3.335	10.47
CICO_TC_Check-Out Controller_mob014	118	118	0	0	0.07	1.495	2.299	2.684	11.678	21.18	21.78	3.607	11.538
CICO_TC_Check-Out Controller_mob013	124	124	0	0	0.074	1.678	2.328	2.766	12.827	17.882	22.479	3.558	12.708
CICO_TC_Check-Out Controller_mob012	117	117	0	0	0.067	1.643	2.341	2.644	12.622	18.409	20.735	3.676	12.495
CICO_TC_Check-Out Controller_mob011	127	127	0	0	0.071	1.67	2.345	2.811	9.401	17.798	24.911	3.285	9.241
CICO_TC_Check-Out Controller_mob010	229	229	0	0	0.128	1.59	2.145	2.5	9.291	16.278	20.679	3.073	9.154
CICO_TC_Check-Out Controller_mob01	100	100	0	0	0.057	1.669	2.321	2.735	10.033	13.425	14.638	3.287	9.916
CICO_TC_Check-Out Controller_fs00001137	247	247	0	0	0.141	1.58	2.636	3.032	9.328	21.968	22.786	3.545	9.197
CICO_TC_Check-In Controller_mob08	229	0	229	100	0	0.778	1.274	1.453	2.26	8.395	16.114	1.609	2.194
CICO_TC_Check-In Controller_mob07	102	102	0	0	0.057	0.913	1.333	1.511	4.552	13.922	17.398	1.904	4.463
CICO_TC_Check-In Controller_mob06	228	228	0	0	0.132	0.837	1.272	1.508	5.336	15.78	18.481	1.863	5.245
CICO_TC_Check-In Controller_mob059	120	120	0	0	0.069	0.83	1.302	1.531	8.978	17.687	18.124	2.093	8.873
CICO_TC_Check-In Controller_mob057	125	125	0	0	0.071	0.884	1.345	1.512	5.138	12.878	14.94	1.814	5.012
CICO_TC_Check-In Controller_mob055	116	116	0	0	0.066	0.832	1.28	1.483	7.169	14.221	20.173	2.03	7.089
CICO_TC_Check-In Controller_mob053	128	128	0	0	0.074	0.725	1.272	1.519	5.393	10.646	15.017	1.73	5.321
CICO_TC_Check-In Controller_mob051	108	108	0	0	0.062	0.831	1.25	1.476	2.386	6.879	10.489	1.521	2.311
CICO_TC_Check-In Controller_mob050	115	115	0	0	0.067	0.832	1.239	1.456	2.323	6.568	7.638	1.463	2.216
CICO_TC_Check-In Controller_mob05	130	130	0	0	0.076	0.849	1.313	1.605	5.817	12.658	14.798	1.876	5.659
CICO_TC_Check-In Controller_mob048	233	233	0	0	0.132	0.773	1.161	1.355	4.315	10.429	17.345	1.608	4.248
CICO_TC_Check-In Controller_mob046	248	248	0	0	0.143	0.804	1.147	1.382	4.875	10.044	17.364	1.627	4.795
CICO_TC_Check-In Controller_mob044	241	241	0	0	0.138	0.703	1.154	1.322	4.114	15.731	18.135	1.643	4.015
CICO_TC_Check-In Controller_mob042	215	215	0	0	0.128	0.687	1.175	1.398	2.576	9.973	13.919	1.565	2.489
CICO_TC_Check-In Controller_mob040	244	244	0	0	0.137	0.786	1.215	1.408	4.025	15.074	17.94	1.696	3.894
CICO_TC_Check-In Controller_mob04	234	234	0	0	0.13	0.762	1.208	1.369	2.09	8.065	10.712	1.455	2.016
CICO_TC_Check-In Controller_mob038	244	244	0	0	0.138	0.752	1.165	1.352	4.34	14.505	17.425	1.623	4.278
CICO_TC_Check-In Controller_mob036	237	237	0	0	0.136	0.778	1.181	1.354	2.148	12.396	15.347	1.578	2.052
CICO_TC_Check-In Controller_mob034	226	226	0	0	0.127	0.792	1.177	1.379	4.62	9.447	20.743	1.64	4.549
CICO_TC_Check-In Controller_mob032	243	243	0	0	0.139	0.81	1.152	1.336	4.269	10.374	17.486	1.586	4.167
CICO_TC_Check-In Controller_mob030	236	236	0	0	0.133	0.73	1.159	1.336	5.022	8.966	16.484	1.577	4.947
CICO_TC_Check-In Controller_mob03	112	112	0	0	0.065	0.841	1.291	1.586	2.137	9.485	12.1	1.622	2.059
CICO_TC_Check-In Controller_mob028	216	216	0	0	0.126	0.803	1.188	1.377	2.357	9.296	10.493	1.462	2.256
CICO_TC_Check-In Controller_mob026	228	228	0	0	0.132	0.781	1.151	1.375	2.358	8.161	10.974	1.449	2.281
CICO_TC_Check-In Controller_mob025	114	114	0	0	0.064	0.894	1.317	1.592	4.849	8.596	13.845	1.812	4.768
CICO_TC_Check-In Controller_mob024	129	129	0	0	0.076	0.812	1.318	1.618	4.316	8.222	13.356	1.772	4.204
CICO_TC_Check-In Controller_mob022	215	215	0	0	0.121	0.742	1.209	1.349	3.064	9.991	16.925	1.577	2.968
CICO_TC_Check-In Controller_mob020	232	232	0	0	0.133	0.813	1.198	1.396	3.494	9.097	10.845	1.575	3.408
CICO_TC_Check-In Controller_mob02	219	219	0	0	0.125	0.821	1.243	1.428	5.575	10.88	21.134	1.735	5.483
CICO_TC_Check-In Controller_mob019	126	126	0	0	0.071	0.794	1.25	1.437	4.272	13.831	14.014	1.781	4.195
CICO_TC_Check-In Controller_mob018	126	126	0	0	0.072	0.856	1.244	1.517	4.606	10.373	19.541	1.745	4.51
CICO_TC_Check-In Controller_mob017	109	109	0	0	0.061	0.899	1.252	1.451	3.835	11.405	15.85	1.715	3.706
CICO_TC_Check-In Controller_mob016	123	123	0	0	0.07	0.833	1.261	1.51	7.255	12.451	13.713	1.889	7.138
CICO_TC_Check-In Controller_mob015	117	117	0	0	0.066	0.815	1.341	1.521	3.632	12.154	16.626	1.768	3.553
CICO_TC_Check-In Controller_mob014	116	116	0	0	0.066	0.863	1.329	1.507	5.983	16.141	23.933	2.003	5.914
CICO_TC_Check-In Controller_mob013	111	111	0	0	0.062	0.888	1.388	1.55	4.9	16.286	16.662	1.972	4.734
CICO_TC_Check-In Controller_mob012	116	116	0	0	0.071	0.874	1.272	1.512	8.331	18.154	18.268	2.126	8.266
CICO_TC_Check-In Controller_mob011	107	107	0	0	0.063	0.891	1.449	1.69	12.513	17.623	26.753	2.531	12.435
CICO_TC_Check-In Controller_mob010	240	240	0	0	0.139	0.828	1.292	1.512	6.431	15.506	21.001	1.986	6.355
CICO_TC_Check-In Controller_mob01	135	135	0	0	0.08	0.84	1.305	1.496	4.339	18.69	21.512	1.951	4.255
CICO_TC_Check-In Controller_fs00001137	223	223	0	0	0.124	1.003	1.604	1.904	6.477	15.9	18.155	2.202	6.393

Expand

title	Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-15 09:48:14.136+00			PARSING_IN_PROGRESS
mob09	10k_bib_Create.mrc	2024-03-15 09:48:19.94+00	2024-03-15 11:15:37.028+00	27:17.1	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-15 09:50:12.897+00	2024-03-15 11:25:39.475+00	35:26.6	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-15 09:50:18.445+00	2024-03-15 11:17:16.497+00	26:58.1	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-15 09:52:13.029+00	2024-03-15 11:29:43.874+00	37:30.8	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-15 09:52:20.202+00	2024-03-15 11:33:21.403+00	41:01.2	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-15 09:54:12.799+00	2024-03-15 11:35:44.009+00	41:31.2	COMMITTED
mob016	10k_bib_Create.mrc	2024-03-15 09:54:19.969+00	2024-03-15 11:31:46.623+00	37:26.7	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-15 09:56:12.801+00	2024-03-15 11:38:27.266+00	42:14.5	COMMITTED
mob018	10k_bib_Create.mrc	2024-03-15 09:56:18.562+00	2024-03-15 11:34:27.767+00	38:09.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-15 09:58:12.638+00	2024-03-15 11:37:06.634+00	38:54.0	COMMITTED
mob021	10k_bib_Create.mrc	2024-03-15 09:58:20.286+00	2024-03-15 11:29:34.553+00	31:14.3	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-15 10:00:12.978+00	2024-03-15 11:31:03.131+00	30:50.2	COMMITTED
mob023	10k_bib_Create.mrc	2024-03-15 10:00:19.596+00	2024-03-15 11:38:57.377+00	38:37.8	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-15 10:02:12.613+00	2024-03-15 11:34:45.687+00	32:33.1	ERROR
mob024	10k_bib_Create.mrc	2024-03-15 10:02:19.299+00	2024-03-15 11:39:41.046+00	37:21.7	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-15 10:04:12.798+00	2024-03-15 11:39:28.367+00	35:15.6	COMMITTED
mob027	10k_bib_Create.mrc	2024-03-15 10:04:20.372+00	2024-03-15 11:34:55.666+00	30:35.3	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-15 10:06:12.892+00	2024-03-15 11:39:30.523+00	33:17.6	COMMITTED
mob029	10k_bib_Create.mrc	2024-03-15 10:06:18.852+00	2024-03-15 11:39:57.627+00	33:38.8	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-15 10:08:13.089+00	2024-03-15 11:39:37.894+00	31:24.8	ERROR
mob031	10k_bib_Create.mrc	2024-03-15 10:08:18.855+00	2024-03-15 11:38:04.502+00	29:45.6	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-15 10:10:12.811+00	2024-03-15 11:39:52.39+00	29:39.6	COMMITTED
mob033	10k_bib_Create.mrc	2024-03-15 10:10:20.114+00	2024-03-15 11:39:08.923+00	28:48.8	COMMITTED
mob015	10k_bib_Create.mrc	2024-03-15 10:12:12.617+00	2024-03-15 11:39:54.161+00	27:41.5	COMMITTED
mob035	10k_bib_Create.mrc	2024-03-15 10:12:19.737+00	2024-03-15 11:39:56.797+00	27:37.1	COMMITTED
mob017	10k_bib_Create.mrc	2024-03-15 10:14:12.646+00	2024-03-15 11:39:51.011+00	25:38.4	COMMITTED
mob037	10k_bib_Create.mrc	2024-03-15 10:14:19.815+00	2024-03-15 11:39:56.405+00	25:36.6	COMMITTED
mob019	10k_bib_Create.mrc	2024-03-15 10:16:13.508+00	2024-03-15 11:39:54.503+00	23:41.0	COMMITTED
mob039	10k_bib_Create.mrc	2024-03-15 10:16:19.156+00	2024-03-15 11:39:55.907+00	23:36.8	COMMITTED

Test №11

DB_MAXSHAREDPOOLSIZE=280 parameter for all 10 modules

Requests

Total per tenant

50th pct

75th pct

95th pct

99th pct

Average

CICO Error

(POST)

DI Duration

DI Error

CICO_TC_Check-In

114

1.12

1.29

9.69

23.65

2.28

3

01:49:14

PARSING

ERROR

CICO_TC_Check-Out

113

2.03

2.39

19.39

28.50

4.28

10

0

Expand

title	Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	120	120	0	0	0.069	0.873	1.448	1.732	12.754	25.598	26.185	2.776	12.665
CICO_TC_Check-In Controller_mob01	119	119	0	0	0.069	0.819	1.17	1.335	9.86	27.468	28.472	2.401	9.787
CICO_TC_Check-In Controller_mob010	116	116	0	0	0.07	0.782	1.112	1.302	13.011	17.909	22.511	2.256	12.902
CICO_TC_Check-In Controller_mob011	112	112	0	0	0.064	0.665	1.129	1.325	12.882	17.005	24.258	2.199	12.807
CICO_TC_Check-In Controller_mob012	119	119	0	0	0.07	0.738	1.087	1.259	3.824	24.539	27.951	2.018	3.756
CICO_TC_Check-In Controller_mob013	103	103	0	0	0.059	0.79	1.152	1.238	4.932	15.324	17.085	1.803	4.838
CICO_TC_Check-In Controller_mob014	117	117	0	0	0.067	0.775	1.2	1.372	12.95	23.078	24.787	2.468	12.857
CICO_TC_Check-In Controller_mob015	114	114	0	0	0.065	0.797	1.115	1.295	10.794	16.581	22.996	2.297	10.723
CICO_TC_Check-In Controller_mob016	110	110	0	0	0.066	0.755	1.135	1.296	13.36	24.814	26.833	2.665	13.272
CICO_TC_Check-In Controller_mob017	114	114	0	0	0.067	0.773	1.116	1.246	4.071	21.096	24.457	1.864	4.01
CICO_TC_Check-In Controller_mob018	108	108	0	0	0.064	0.725	1.097	1.232	6.222	24.031	27.198	2.157	5.934
CICO_TC_Check-In Controller_mob019	116	116	0	0	0.066	0.696	1.134	1.29	13.748	27.546	29.21	2.633	13.667
CICO_TC_Check-In Controller_mob02	114	114	0	0	0.063	0.76	1.149	1.342	6.426	25.713	28.407	2.354	6.345
CICO_TC_Check-In Controller_mob020	100	100	0	0	0.056	0.785	1.16	1.345	13.293	20.222	24.95	2.436	13.196
CICO_TC_Check-In Controller_mob021	113	113	0	0	0.065	0.698	1.124	1.279	9.103	23.595	27.112	2.092	9.026
CICO_TC_Check-In Controller_mob022	114	114	0	0	0.068	0.802	1.105	1.26	13.22	27.833	28.856	2.661	13.122
CICO_TC_Check-In Controller_mob023	114	114	0	0	0.067	0.708	1.069	1.24	8.382	23.28	26.004	2.126	8.301
CICO_TC_Check-In Controller_mob024	129	129	0	0	0.073	0.777	1.08	1.223	2.945	9.301	22.174	1.5	2.863
CICO_TC_Check-In Controller_mob025	117	117	0	0	0.066	0.778	1.077	1.262	6.956	21.096	29.382	2.018	6.863
CICO_TC_Check-In Controller_mob026	101	101	0	0	0.059	0.789	1.09	1.291	14.105	28.315	29.374	2.736	14.018
CICO_TC_Check-In Controller_mob027	118	118	0	0	0.067	0.749	1.095	1.328	13.985	26.632	27.556	2.57	13.855
CICO_TC_Check-In Controller_mob028	125	125	0	0	0.072	0.723	1.084	1.266	9.027	20.001	23.033	1.995	8.943
CICO_TC_Check-In Controller_mob029	102	102	0	0	0.058	0.806	1.131	1.34	9.8	16.191	25.663	2.145	9.708
CICO_TC_Check-In Controller_mob03	123	123	0	0	0.073	0.737	1.09	1.233	8.859	27.053	27.977	2.241	8.766
CICO_TC_Check-In Controller_mob030	109	109	0	0	0.062	0.771	1.09	1.244	7.297	21.509	28.416	1.94	7.233
CICO_TC_Check-In Controller_mob031	118	118	0	0	0.069	0.755	1.137	1.312	9.416	25.342	27.177	2.245	9.333
CICO_TC_Check-In Controller_mob032	114	114	0	0	0.066	0.795	1.107	1.3	12.635	28.057	28.339	2.619	12.574
CICO_TC_Check-In Controller_mob033	130	130	0	0	0.076	0.777	1.125	1.304	10.567	28.25	33.249	2.364	10.478
CICO_TC_Check-In Controller_mob034	117	117	0	0	0.07	0.802	1.096	1.242	3.703	22.763	28.24	1.961	3.62
CICO_TC_Check-In Controller_mob035	118	118	0	0	0.067	0.678	1.069	1.28	9.53	22.279	23.914	2.013	9.475
CICO_TC_Check-In Controller_mob036	107	107	0	0	0.062	0.749	1.135	1.317	12.184	27.096	28.109	2.519	12.083
CICO_TC_Check-In Controller_mob037	124	124	0	0	0.072	0.687	1.103	1.253	16.472	28.232	32.279	2.657	16.385
CICO_TC_Check-In Controller_mob038	123	123	0	0	0.074	0.696	1.082	1.247	6.904	27.952	28.494	2.039	6.819
CICO_TC_Check-In Controller_mob039	105	105	0	0	0.063	0.799	1.112	1.26	11.695	24.107	27.813	2.358	11.626
CICO_TC_Check-In Controller_mob04	125	125	0	0	0.072	0.757	1.126	1.36	13.955	24.498	29.148	2.501	13.871
CICO_TC_Check-In Controller_mob040	114	114	0	0	0.068	0.798	1.113	1.307	5.28	21.963	26.526	1.953	5.179
CICO_TC_Check-In Controller_mob041	111	111	0	0	0.064	0.813	1.092	1.227	3.14	20.977	26.231	1.717	3.078
CICO_TC_Check-In Controller_mob042	106	106	0	0	0.061	0.759	1.111	1.294	11.209	27.599	28.143	2.343	11.119
CICO_TC_Check-In Controller_mob043	115	115	0	0	0.069	0.808	1.105	1.303	8.776	27.587	27.769	2.572	8.655
CICO_TC_Check-In Controller_mob044	113	113	0	0	0.066	0.761	1.105	1.272	10.124	25.358	27.203	2.458	10.022
CICO_TC_Check-In Controller_mob045	113	113	0	0	0.065	0.779	1.131	1.304	8.867	17.495	24.908	2.212	8.761
CICO_TC_Check-In Controller_mob046	116	116	0	0	0.067	0.812	1.133	1.258	2.163	25.669	27.989	2.063	2.101
CICO_TC_Check-In Controller_mob047	104	104	0	0	0.061	0.741	1.137	1.29	11.298	26.806	28.831	2.324	11.224
CICO_TC_Check-In Controller_mob048	120	120	0	0	0.068	0.762	1.151	1.394	11.062	25.75	31.964	2.597	10.95
CICO_TC_Check-In Controller_mob049	112	112	0	0	0.065	0.736	1.131	1.309	6.775	24.942	29.979	2.302	6.7
CICO_TC_Check-In Controller_mob05	109	109	0	0	0.061	0.787	1.151	1.323	9.085	20.703	24.489	2.184	8.981
CICO_TC_Check-In Controller_mob050	111	110	1	0.901	0.064	0.741	1.134	1.273	4.973	27.635	29.969	2.176	4.89
CICO_TC_Check-In Controller_mob051	107	107	0	0	0.062	0.775	1.095	1.217	10.564	17.139	31.123	2.262	10.463
CICO_TC_Check-In Controller_mob052	115	114	1	0.87	0.066	0.748	1.109	1.277	9.364	25.864	31.724	2.417	9.29
CICO_TC_Check-In Controller_mob053	121	121	0	0	0.07	0.745	1.091	1.287	19.278	29.528	31.431	2.705	19.202
CICO_TC_Check-In Controller_mob054	107	107	0	0	0.062	0.692	1.132	1.326	14.135	25.77	30.53	2.413	14.063
CICO_TC_Check-In Controller_mob055	110	110	0	0	0.063	0.677	1.177	1.318	18.105	26.392	29.35	2.647	18.038
CICO_TC_Check-In Controller_mob056	119	119	0	0	0.07	0.762	1.095	1.262	9.039	22.698	29.083	2.187	8.957
CICO_TC_Check-In Controller_mob057	118	118	0	0	0.067	0.674	1.085	1.238	2.64	14.531	26.124	1.724	2.571
CICO_TC_Check-In Controller_mob058	126	125	1	0.794	0.075	0.721	1.135	1.288	10.979	29.013	29.245	2.319	10.898
CICO_TC_Check-In Controller_mob059	118	118	0	0	0.07	0.78	1.117	1.254	15.707	24.284	28.641	2.499	15.619
CICO_TC_Check-In Controller_mob06	103	103	0	0	0.057	0.826	1.169	1.314	10.143	31.001	32.079	2.616	10.054
CICO_TC_Check-In Controller_mob060	117	117	0	0	0.067	0.716	1.079	1.211	5.197	20.715	25.788	1.903	5.12
CICO_TC_Check-In Controller_mob07	116	116	0	0	0.068	0.839	1.118	1.283	7.446	25.108	27.235	2.084	7.371
CICO_TC_Check-In Controller_mob08	115	0	115	100	0	0.735	1.107	1.266	9.569	21.203	26.718	2.283	9.48
CICO_TC_Check-In Controller_mob09	112	112	0	0	0.062	0.717	1.144	1.344	7.396	22.664	24.86	2.243	7.31
CICO_TC_Check-Out Controller_fs00001137	109	107	2	1.835	0.061	1.864	2.664	3.282	23.102	33.836	37.204	5.161	22.953
CICO_TC_Check-Out Controller_mob01	110	110	0	0	0.062	1.383	2.055	2.382	23.072	32.978	38.543	4.408	22.951
CICO_TC_Check-Out Controller_mob010	112	112	0	0	0.063	1.377	1.987	2.307	17.292	29.007	29.679	4.279	17.164
CICO_TC_Check-Out Controller_mob011	117	117	0	0	0.066	1.429	2.011	2.399	17.778	29.771	31.444	4.431	17.648
CICO_TC_Check-Out Controller_mob012	109	109	0	0	0.061	1.467	2.097	2.55	21.684	26.16	30.535	4.208	21.554
CICO_TC_Check-Out Controller_mob013	125	125	0	0	0.07	1.372	2.071	2.438	21.51	29.463	30.434	4.853	21.358
CICO_TC_Check-Out Controller_mob014	111	111	0	0	0.062	1.503	2.001	2.261	16.692	27.935	34.013	4.132	16.553
CICO_TC_Check-Out Controller_mob015	115	115	0	0	0.065	1.492	2.015	2.272	22.228	30.699	31.282	4.703	22.105
CICO_TC_Check-Out Controller_mob016	118	118	0	0	0.066	1.436	2.026	2.379	17.551	26.255	26.48	4.055	17.455
CICO_TC_Check-Out Controller_mob017	116	116	0	0	0.066	1.481	2.023	2.343	14.597	26.451	31.398	4.029	14.466
CICO_TC_Check-Out Controller_mob018	121	120	1	0.826	0.069	1.37	2.019	2.486	21.359	28.966	35.119	4.843	21.212
CICO_TC_Check-Out Controller_mob019	112	112	0	0	0.066	1.529	1.96	2.197	13.418	29.418	29.732	3.632	13.282
CICO_TC_Check-Out Controller_mob02	115	115	0	0	0.066	1.526	2.012	2.33	19.413	27.135	31.764	4.496	19.309
CICO_TC_Check-Out Controller_mob020	129	129	0	0	0.075	1.306	1.955	2.28	21.893	30.569	31.625	4.183	21.554
CICO_TC_Check-Out Controller_mob021	115	115	0	0	0.066	1.141	2.009	2.292	20.314	25.289	27.984	3.853	20.205
CICO_TC_Check-Out Controller_mob022	114	114	0	0	0.065	1.289	1.97	2.284	15.165	27.107	32.614	3.858	15.011
CICO_TC_Check-Out Controller_mob023	114	114	0	0	0.064	1.518	2.025	2.346	15.301	28.094	29.419	4.289	15.178
CICO_TC_Check-Out Controller_mob024	99	99	0	0	0.057	1.431	2.036	2.564	28.12	32.314	32.325	5.444	27.969
CICO_TC_Check-Out Controller_mob025	112	112	0	0	0.065	1.382	2.015	2.853	24.224	29.174	35.051	5.279	24.11
CICO_TC_Check-Out Controller_mob026	126	126	0	0	0.071	1.472	2.009	2.291	14.977	24.659	29.523	3.612	14.816
CICO_TC_Check-Out Controller_mob027	110	110	0	0	0.066	1.496	2.004	2.367	20.527	29.28	29.332	4.264	20.388
CICO_TC_Check-Out Controller_mob028	103	103	0	0	0.058	1.586	2.025	2.428	17.245	25.314	31.443	4.056	17.147
CICO_TC_Check-Out Controller_mob029	126	126	0	0	0.073	1.416	1.948	2.212	24.008	29.128	29.22	4.112	23.865
CICO_TC_Check-Out Controller_mob03	105	104	1	0.952	0.059	1.491	2.045	2.409	13.14	26.617	27.874	3.576	13.048
CICO_TC_Check-Out Controller_mob030	119	119	0	0	0.072	1.523	2.039	2.47	21.964	28.146	29.13	4.317	21.85
CICO_TC_Check-Out Controller_mob031	111	110	1	0.901	0.063	1.421	1.979	2.471	16.242	27.327	29.335	4.275	16.112
CICO_TC_Check-Out Controller_mob032	113	112	1	0.885	0.064	1.523	2.024	2.401	20.739	29.877	30.021	4.413	20.634
CICO_TC_Check-Out Controller_mob033	98	98	0	0	0.055	1.468	2	2.377	16.965	27.762	29.284	4.083	16.821
CICO_TC_Check-Out Controller_mob034	112	112	0	0	0.063	1.427	2.001	2.448	16.566	25.092	31.43	4.165	16.436
CICO_TC_Check-Out Controller_mob035	111	111	0	0	0.064	1.398	2.02	2.37	19.458	33.012	35.742	4.102	19.343
CICO_TC_Check-Out Controller_mob036	121	121	0	0	0.069	1.488	1.978	2.413	15.64	25.452	28.085	3.667	15.509
CICO_TC_Check-Out Controller_mob037	104	104	0	0	0.059	1.507	2.023	2.35	23.108	30.639	34.904	4.455	23.006
CICO_TC_Check-Out Controller_mob038	104	104	0	0	0.06	1.462	1.982	2.318	20.06	29.907	31.43	4.132	19.926
CICO_TC_Check-Out Controller_mob039	123	123	0	0	0.07	1.496	1.957	2.367	22.917	28.295	29.302	4.163	22.806
CICO_TC_Check-Out Controller_mob04	102	100	2	1.961	0.058	1.464	2.055	2.368	16.717	27.25	29.53	3.946	16.626
CICO_TC_Check-Out Controller_mob040	115	115	0	0	0.065	1.305	1.95	2.311	20.567	32.445	38.41	4.235	20.456
CICO_TC_Check-Out Controller_mob041	118	118	0	0	0.067	1.495	2.034	2.479	18.245	30.274	31.417	4.455	18.151
CICO_TC_Check-Out Controller_mob042	122	122	0	0	0.069	1.415	2.014	2.281	18.411	27.449	29.986	4.093	18.27
CICO_TC_Check-Out Controller_mob043	114	114	0	0	0.065	1.451	2.013	2.338	16.617	28.476	29.386	4.129	16.504
CICO_TC_Check-Out Controller_mob044	116	116	0	0	0.066	1.468	2.061	2.382	18.529	26.052	28.961	4.249	18.421
CICO_TC_Check-Out Controller_mob045	115	115	0	0	0.066	1.446	1.994	2.315	22.951	29.782	32.42	4.52	22.855
CICO_TC_Check-Out Controller_mob046	113	113	0	0	0.064	1.456	2.037	2.508	18.93	28.693	29.696	4.399	18.804
CICO_TC_Check-Out Controller_mob047	123	123	0	0	0.07	1.437	2.02	2.33	19.914	27.447	29.893	4.311	19.799
CICO_TC_Check-Out Controller_mob048	109	109	0	0	0.064	1.438	2.027	2.311	22.571	30.733	34.504	4.056	22.442
CICO_TC_Check-Out Controller_mob049	115	115	0	0	0.066	1.381	1.996	2.252	23.741	30.572	30.658	4.326	23.635
CICO_TC_Check-Out Controller_mob05	121	121	0	0	0.072	1.558	2.082	2.415	21.616	26.947	30.573	4.74	21.484
CICO_TC_Check-Out Controller_mob050	117	117	0	0	0.067	1.466	1.987	2.369	14.65	25.478	27.062	3.863	14.557
CICO_TC_Check-Out Controller_mob051	120	120	0	0	0.069	1.529	1.996	2.233	17.455	31.583	32.02	4.139	17.352
CICO_TC_Check-Out Controller_mob052	112	112	0	0	0.065	1.483	1.998	2.379	12.602	30.95	31.062	3.746	12.511
CICO_TC_Check-Out Controller_mob053	107	107	0	0	0.062	1.4	2.067	2.277	12.298	30.156	31.614	3.666	12.176
CICO_TC_Check-Out Controller_mob054	119	118	1	0.84	0.07	1.611	2.02	2.311	21.779	27.67	30.76	4.232	21.663
CICO_TC_Check-Out Controller_mob055	117	117	0	0	0.068	1.464	1.973	2.283	23.408	30.839	32.237	4.366	23.299
CICO_TC_Check-Out Controller_mob056	108	108	0	0	0.062	1.544	2.051	2.486	25.326	27.483	30.287	4.729	25.225
CICO_TC_Check-Out Controller_mob057	109	108	1	0.917	0.064	1.588	2.056	2.272	23.681	26.301	33.491	4.485	23.565
CICO_TC_Check-Out Controller_mob058	101	101	0	0	0.058	1.519	2.051	2.433	18.213	25.623	26.446	4.123	18.107
CICO_TC_Check-Out Controller_mob059	109	109	0	0	0.062	1.503	2.05	2.331	14.373	24.343	30.694	3.739	14.242
CICO_TC_Check-Out Controller_mob06	126	126	0	0	0.072	1.498	2.014	2.36	17.188	25.397	26.982	3.879	17.07
CICO_TC_Check-Out Controller_mob060	112	112	0	0	0.066	1.432	2.032	2.461	23.767	29.863	32.688	4.764	23.637
CICO_TC_Check-Out Controller_mob07	112	111	1	0.893	0.063	1.576	2.062	2.451	18.459	27.998	28.942	4.585	18.342
CICO_TC_Check-Out Controller_mob08	114	114	0	0	0.064	1.468	2.046	2.544	24.513	31.987	34.21	5.111	24.377
CICO_TC_Check-Out Controller_mob09	117	117	0	0	0.067	1.416	2.052	2.424	18.254	25.795	31.471	4.476	18.122

Expand

title	Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-15 13:25:02.356+00	2024-03-15 13:33:52.021+00	08:49.7	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-15 13:27:01.324+00	2024-03-15 13:53:56.135+00	26:54.8	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-15 13:29:01.34+00	2024-03-15 14:08:49.275+00	39:47.9	COMMITTED
fs00001137	10k_bib_Create.mrc	2024-03-15 13:30:45.536+00	2024-03-15 14:22:18.418+00	51:32.9	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-15 13:31:01.421+00	2024-03-15 14:23:50.88+00	52:49.5	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-15 13:32:45.004+00	2024-03-15 14:43:51.312+00	11:06.3	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-15 13:33:01.453+00	2024-03-15 14:24:50.14+00	51:48.7	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-15 13:34:44.936+00	2024-03-15 14:54:34.343+00	19:49.4	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-15 13:35:01.502+00	2024-03-15 14:28:41.692+00	53:40.2	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-15 13:36:44.945+00	2024-03-15 15:05:04.392+00	28:19.4	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-15 13:37:01.437+00	2024-03-15 14:32:02.557+00	55:01.1	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-15 13:38:45.107+00	2024-03-15 15:05:46.569+00	27:01.5	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-15 13:39:01.627+00	2024-03-15 14:35:59.833+00	56:58.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-15 13:40:45.099+00	2024-03-15 15:08:45.875+00	28:00.8	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-15 13:41:01.656+00	2024-03-15 14:37:00.744+00	55:59.1	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-15 13:42:44.949+00	2024-03-15 15:10:57.728+00	28:12.8	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-15 13:43:01.602+00	2024-03-15 14:38:38.344+00	55:36.7	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-15 13:44:45.706+00	2024-03-15 15:13:27.756+00	28:42.0	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-15 13:45:03.883+00	2024-03-15 14:40:32.307+00	55:28.4	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-15 13:46:45.284+00	2024-03-15 15:13:30.595+00	26:45.3	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-15 13:47:01.461+00	2024-03-15 14:40:43.434+00	53:42.0	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-15 13:48:44.944+00	2024-03-15 15:13:56.003+00	25:11.1	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-15 13:49:01.587+00	2024-03-15 14:42:04.212+00	53:02.6	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-15 13:50:44.918+00	2024-03-15 15:14:04.345+00	23:19.4	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-15 13:51:01.466+00	2024-03-15 14:43:43.98+00	52:42.5	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-15 13:52:44.943+00	2024-03-15 15:14:04.974+00	21:20.0	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-15 13:53:01.49+00	2024-03-15 14:44:37.385+00	51:35.9	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-15 13:54:44.885+00	2024-03-15 15:14:13.252+00	19:28.4	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-15 13:56:45.096+00	2024-03-15 15:14:18.109+00	17:33.0	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-15 13:58:44.974+00	2024-03-15 15:14:16.993+00	15:32.0	COMMITTED

...

DB connections was 2864.

DB load

DB for test was db.r6g4xlarge

...

Tests involving data import are experiencing errors due to database connection timeouts.

error in UI

error in Logs Insights

Appendix

Infrastructure

PTF - environment pmpt

10 m6g.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instances, writer

Name Memory GIB vCPUs
db.r6g.4xlarge
128 GiB 16 vCPUs
MSK ptf-mobius-testing2
- 2 m5.2xlarge brokers in 2 zones
- Apache Kafka version 2.8.0
- EBS storage volume per broker 300 GiB
- auto.create.topics.enable=true
- log.retention.minutes=480
- default.replication.factor=2

...

Version	Old Version 89	New Version Current
Changes made by	Stanislav Nehrii	Stanislav Nehrii
Saved on	Apr 03, 2024	Apr 03, 2024

Versions Compared

Key

Test Results

Baseline Test

Test №8

Test №9

Test №10

Test №11

DB load

Appendix

Infrastructure

Content Comparison

Versions Compared

Key

Test Results

Baseline Test

Test №8

Test №9

Test №10

Test №11

DB load

Appendix

Infrastructure