]> git.koha-community.org Git - koha.git/commit
Bug 3445: add more indexes on the action_logs table
authorFridolyn SOMERS <fridolyn.somers@biblibre.com>
Tue, 19 Nov 2013 10:21:13 +0000 (11:21 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Tue, 27 May 2014 14:36:58 +0000 (16:36 +0200)
commit0f1562c429e7d05091011ae241871eb4e6a4c333
tree51b536ebc11270637daef129f821f329a5d64390
parent442046712bfdcf2285785ef500210342794a758e
Bug 3445: add more indexes on the action_logs table

This patch adds database indexes for action_logs table to speed up the
"log viewer" page.

Removes the existing index on timestamp+user to add an index on each
column since search colums are 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.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit 6f728fb05062fc549a635a82970f7dc10f0f9748)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl