| 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 | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Crowdfunding goal: | 0 | 
| 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  |