[Koha-bugs] [Bug 3445] action_logs table needs some thought

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3445

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #23222|0                           |1
        is obsolete|                            |

--- Comment #7 from Katrin Fischer <katrin.fischer at 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 at univ-rennes2.fr>

Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at 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.