http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9207
Bug ID: 9207
Summary: Improve z39.50 speed slowdowns for sites with many
records
Classification: Unclassified
Change sponsored?: ---
Product: Koha
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Cataloging
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Sites with very large numbers of imported records may experience increasingly
slow z39.50 searches. This is cause by the triggering of the subroutine
_update_batch_record_counts for each and every result of a z39.50 search.
Fixing this will be very difficult though.
However, I have discovered a much simpler solution that, while not as good as
bypassing _update_batch_record_counts, still gives a dramatic boost to speed,
adding an index to import_records for import_batch_id/record_type
ALTER TABLE import_records ADD INDEX batch_id__record_type (
import_batch_id, record_type )
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
