[Koha-bugs] [Bug 20664] Optimize retrieval of biblio and item data

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20664

--- Comment #1 from Ere Maijala <ere.maijala at helsinki.fi> ---
Created attachment 74873
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=74873&action=edit
Bug 20664: Optimize retrieval of biblio and item data

Optimizes embedding of item data in MARC and fixes several bottlenecks
encountered while profiling OAI-PMH and exporting of records. There are three
ways this is accomplished:

1.) Use state variables to hold prepared SQL statements so that the preparation
is done only once.
2.) Create optimized method for fetching item fields for MARC embedding.
3.) Use the cache service more and where repeated calls are made.

Test plan:

1.) Before applying the patch, time an export_records.pl run for a set of
biblios that also have items. Run it a couple of times to account for initial
slowness and possible fluctuations. For example:

time misc/export_records.pl --record-type bibs --starting_biblionumber 960000
--ending_biblionumber 965000 --format xml --filename unoptimized.xml

2.) Apply the patch.

3.) Time the export process again with a different output file:

time misc/export_records.pl --record-type bibs --starting_biblionumber 960000
--ending_biblionumber 965000 --format xml --filename optimized.xml

4.) Verify that the optimized process is faster.

5.) Compare the resulting export files to make sure they're identical:

diff -u unoptimized.xml optimized.xml

-- 
You are receiving this mail because:
You are watching all bug changes.