[Koha-bugs] [Bug 33116] New: Limit reports execution time with sql variables

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33116

            Bug ID: 33116
           Summary: Limit reports execution time with sql variables
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: didier.gautheron at biblibre.com
        QA Contact: testopia at bugs.koha-community.org

Users' SQL reports can run for a very long time and users can create cartesean
products which severely impact server performance.
Moreover it doesn't help there's a lot of sample koha reports using the old
cartesean prone join synxtax.

This patch add two optional koha-conf parameters:
- report_sql_max_statement_time for mysql sql_max_statement_time
- report_sql_max_join_size for sql_max_join_size

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.