Bug 33502

Summary: Run reports against a replicated database
Product: Koha Reporter: Magnus Enger <magnus>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33116
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Magnus Enger 2023-04-12 08:20:09 UTC
One potential problem when running Koha is that someone can create a report that makes the database really slow and/or crash. 

This will be mitigated to some extent by bug 33116, but for sites that have a setup where the database is replicated to a second database server, it could be interesting to be able to direct queries generated by reports to the replica, not to the main server. Then a heavy/slow/big report would only affect the replica, not the main database.