---- Reported by gmcharlt@gmail.com 2010-02-08 17:46:28 ---- Commit 943aa38564c tries to address a performance issue in the display and search of extended patron attributes during overdue notice generation by disabling a feature that had been sponsored by a library (added in commit ab44e2986a0). On initial glance, adding additional indexes to authorised_values, borrower_attributes, and borrower_attribute_types should improve the performance of the query. Note to all re regarding 943aa38564c: if you find a performance problem, please don't simply disable a feature - please fix the actual problem. The performance issue is real, hence I'm marking this as a blocker for 3.2. ---- Additional Comments From gmcharlt@gmail.com 2010-02-10 15:46:49 ---- I will work on the database updates. --- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:23 UTC --- This bug was previously known as _bug_ 4139 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4139 Actual time not defined. Setting to 0.0 Setting qa contact to the default for this product. This bug either had no qa contact or an invalid one.
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.