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
Created attachment 147689 [details] [review] Bug 33116: Add sql statement limit to report query
Is this "work in progress" or should it be "Needs Signoff"? If it is meant for signoff, I think it also needs to update etc/koha-conf.xml, and include a test plan. But this sure sounds like something that will be a good thing to have!