[Koha-bugs] [Bug 9207] New: Improve z39.50 speed slowdowns for sites with many records

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

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 at gmail.com
          Reporter: kyle at bywatersolutions.com
                CC: m.de.rooy at 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.