Skip to main content

Slow queue loading in osTicket with many custom queues. MySQL queries take 40+ seconds due to massive REGEXP-based COUNT statements.

osTicket: 1.14.x - 1.18.3 Checked:

Apply the patch to class.search.php to switch from a single combined COUNT query to individual per-queue getTotal() calls. This eliminates the REGEXP explosion caused by multi-value custom queue conditions. Report of improvement: queries that took 40+ seconds dropped to under 1 second in production environments with hundreds of custom queues and thousands of tickets.

Originally sourced from forum.osticket.com . osFAQ.org summarises community knowledge for quick reference.

Helpful
Report an error