Data Import with Check-ins Check-outs (Quesnelia)[non-ECS]
Overview
This document contains the results of testing Check-in/Check-out and Data Import for MARC Bibliographic records in the Quesnelia release.
Ticket: - PERF-824Getting issue details... STATUS
Summary
- Data import tests finished successfully for all files. Duration of DI grew in correspondence with the number of records in files.
- Check-in and Check-out with 8 virtual users was performed during DI Create and Update jobs. No issues.
- Data Import in Quesnelia with CICO perform faster than without it.
- Comparing Poppy and Quesnelia releases
- Check-in / Check-out perform better in Quesnelia. Response time improved during Create jobs - 30% in Average, and during DI Update jobs - 15% in Average.
- DI durations do not differ much
- Resource utilization
- Average CPU utilization did not exceed 150% for all modules. The highest consumption observed from mod-inventory - 144% in DI Update job with 25k file. The same maximum level as in Poppy.
- No memory leaks observed during tests.
- Average DB CPU usage during data import has 5% decreasing in Quesnelia - close to 90%.
- Average connection count during data import is about 750 connections for create jobs that is 450 connections higher than in Poppy. For update jobs - 730 connections.
Test Runs
Test # | Scenario | Load level | Comment |
---|---|---|---|
1 | DI MARC Bib Create | 5K, 10K, 25K, 50K, 100K consequentially | |
CICO | 8 users | ||
2 | DI MARC Bib Update | 5K, 10K, 25K, 50K, 100K consequentially | |
CICO | 8 users |
Test Results
Data import
Files for Data Import update jobs prepared during previous tests. So no need to run Data Export.
Profile | MARC File |
Quesnelia (hh:mm:ss) | Check In, Check Out Response time (8 users) Quesnelia | |
---|---|---|---|---|
CI Average sec | CO Average sec | |||
DI MARC Bib Create (PTF - Create 2) | 5K.mrc | 00:02:32 | 0.645 | 0.901 |
10K.mrc | 00:05:03 | 0.628 | 0.922 | |
25K.mrc | 00:11:58 | 0.639 | 0.960 | |
50K.mrc | 00:23:29 | 0.678 | 1.003 | |
100K.mrc | 00:46:07 | 0.686 | 0.998 | |
DI MARC Bib Update (PTF - Updates Success - 1) | 5K.mrc | 00:03:24 | 0.628 | 0.975 |
10K.mrc | 00:06:29 | 0.664 | 1.018 | |
25K.mrc | 00:16:15 | 0.717 | 1.062 | |
50K.mrc | 00:33:33 | 0.721 | 1.071 | |
100K.mrc | 01:10:14 | 0.739 | 1.081 |
Check-in/Check-out without DI
Scenario | Load level | Request | Response time, sec Quesnelia | |
---|---|---|---|---|
95 perc | average | |||
Circulation Check-in/Check-out (without Data import) | 8 users | Check-in | 0.609 | 0.521 |
Check-out | 1.070 | 0.803 |
Comparison
CICO