Summary: | Improve z39.50 speed slowdowns for sites with many records | ||
---|---|---|---|
Product: | Koha | Reporter: | Kyle M Hall (khall) <kyle> |
Component: | Cataloging | Assignee: | Kyle M Hall (khall) <kyle> |
Status: | CLOSED FIXED | QA Contact: | Marcel de Rooy <m.de.rooy> |
Severity: | minor | ||
Priority: | P5 - low | CC: | chris, m.de.rooy |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | Trivial patch |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Attachments: |
Bug 9207 - Improve z39.50 speed slowdowns for sites with many records
Bug 9207 - Improve z39.50 speed slowdowns for sites with many records |
Description
Kyle M Hall (khall)
2012-12-04 13:47:44 UTC
Created attachment 13872 [details] [review] Bug 9207 - Improve z39.50 speed slowdowns for sites with many records Depending on the number of servers that are being searched, there may be a lesser slowdown caused by ZOOM not releasing the resultsets and connections after it's done. Whether this is making a difference in your particular case, of course, I couldn't say. Created attachment 15967 [details] [review] Bug 9207 - Improve z39.50 speed slowdowns for sites with many records Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> I tested the new index, but it is hard to say if it is really faster with just a few thousand records in import_records. I have timed with Time::HiRes a few times, and got slightly better results. But just running the queries like _update_batch_record_counts does in mysql did not really make a difference. Nevertheless, I can imagine that this index makes a difference when you have much more records. Tested the upgrade. Tested the install by running kohastructure partially from command-line. Amended the patch for a small detail: there is no index in Koha with two underscores in the name. So I removed one underscore. No further QA comments: Passed QA This patch has been pushed to master. Pushed to 3.10.x and 3.8.x will be in 3.10.4 and 3.8.11 |