Overview

• This document contains the results of testing Check-in/Check-out and Data Import for MARC Bibliographic records on the Ramsons[NON-ECS] release environment. 

https://folio-org.atlassian.net/browse/PERF-969 

Summary

• Data Import with Check In/Check Out tests finished successfully with PTF - Create 2 and PTF - Updates Success - 2 job profiles with files 5K, 10K, 25K, 50K, 100K records.

• Instance type was updated from m6i.2xlarge to r7g.2xlarge

• Comparing with previous testing results Quesnelia and Ramsons releases

  • Check-in duration degraded by 20% and Check-out duration degraded by 40% on average without Data Import

  • Data Import Create jobs duration without CI/CO degraded by 5%-30%, depending on file size

  • Data Import Update jobs durations without CI/CO degraded by 44%-138%, depending on file size

  • Data Import Create jobs duration with CI/CO degraded by 15%-40%, depending on file size

  • Data Import Update jobs durations with CI/CO degraded by two times.

  • Check-in duration degraded by 20% and Check-out duration degraded by 40% on average for Data Import Create

  • Check-in duration degraded by 40% and Check-out duration degraded by 45% on average for Data Import Update

• During the test, a slow SQL query was detected with a latency of 28,32 seconds.

Test Runs 

Test Results

This table contains durations for Data Import with Check-in/Check-out. 

Check-in/Check-out without Data Import

Comparison

This table contains DI durations with CICO comparison between Quesnelia and Ramsons releases.