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: gmcharlt@gmail.com Reporter: kyle@bywatersolutions.com CC: m.de.rooy@rijksmuseum.nl 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.