http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3445 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #23222|0 |1 is obsolete| | --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 23866 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23866&action=edit [PASSED QA] Bug 3445 - action_logs table needs indexes This patch adds database indexes for action_logs table to speed up "log viewer" page. Removes the existing index on timestamp+user to add an indexe on each column since earch colums is separately defined in log viewer form. Test plan: - Update database - Play with log viewer : /cgi-bin/koha/tools/viewlog.pl - Perform searches with only one filter defined - Also check you see indexes with SQL query : SHOW CREATE TABLE action_logs Signed-off-by: Mathieu Saby <mathieu.saby@univ-rennes2.fr> Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> Rephrased the updatedatabase message a bit: Add indexes to action_logs table Passes all tests and QA script. -- You are receiving this mail because: You are watching all bug changes.