Bug 29016 - Log viewer has problems with many entries
Summary: Log viewer has problems with many entries
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-14 13:54 UTC by Vitor Fernandes
Modified: 2023-11-10 12:08 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.