Bug 29016

Summary: Log viewer has problems with many entries
Product: Koha Reporter: Vitor Fernandes <vitorfernandes87>
Component: ToolsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: andreas.jonsson, dcook, marie.hedbom
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Vitor Fernandes 2021-09-14 13:54:22 UTC
The script viewlog.pl it's very slow because it retrieves all action logs at the same time. It should use KohaTables with pagination/number max of returning entries like other Koha tables (API + AJAX wrapper).

Test plan:

- We need a database with a large number of entries in the action_logs table (200k for example)
- Open view logs tool (viewlog.pl)
- Select all modules and search
- Timeout or a long waiting time
Comment 1 David Cook 2023-05-05 06:41:08 UTC
I have a library that gets timeouts when trying to use viewlog.pl. 

The timeouts come from a HTTP forward proxy that times out after 60 seconds, so it would be interesting to have an AJAX driven DataTable that only returned a small number of logs at a time.