[Koha-bugs] [Bug 4139] overdue notice generation performance issue
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Jul 6 10:58:19 CEST 2010
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4139
--- Comment #2 from Chris Cormack <chris at 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.
More information about the Koha-bugs
mailing list