http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4139 --- Comment #2 from Chris Cormack <chris@bigballofwax.co.nz> --- 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.