Summary: | overdue notice generation performance issue | ||
---|---|---|---|
Product: | Koha | Reporter: | Galen Charlton <gmcharlt> |
Component: | Circulation | Assignee: | Galen Charlton <gmcharlt> |
Status: | CLOSED FIXED | QA Contact: | Bugs List <koha-bugs> |
Severity: | blocker | ||
Priority: | PATCH-Sent (DO NOT USE) | CC: | chris |
Version: | rel_3_2 | ||
Hardware: | PC | ||
OS: | All | ||
URL: | circ/overdue.pl | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
Description
Chris Cormack
2010-05-21 01:23:36 UTC
Galen, does this still need to be done? If so I can work on the update script Ok, a couple of indexes make a big difference create index auth_value_idx on authorised_values (authorised_value); create index auth_val_cat_idx on borrower_attribute_types (authorised_value_category); Before the indexes 55599 rows in set (2.77 sec) After 55599 rows in set (0.62 sec) Will update the kohastructure.sql and and updatedatabase.pl Pushed fix. Performance gain is good enough for me, so closing. |