http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3445
Katrin Fischer <katrin.fisc...@bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #23222|0 |1
is obsolete| |
--- Comment #7 from Katrin Fischer <katrin.fisc...@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.s...@univ-rennes2.fr>
Signed-off-by: Katrin Fischer <katrin.fischer...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
