[Koha-bugs] [Bug 4139] overdue notice generation performance issue

[bugzilla-daemon at bugs.koha-community.org]

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.