Hi
We have more than 30000 tickets and when we open the closed ticket view it takes about 20 seconds to open. I took a look at the sql query and it seems to be because of some thread subqueries in the select statement that are used by the Subject column.

If i remove the Subject column from the closed view, then it only takes 2 seconds to open.

Could you optimize the query or maybe create a column called Subject (fast) that doesn't use the thread subqueries? Or maybe you have a better solution.

Thanks in advance. 😀

osTicket Version v1.14.3 (f4f5bc6) — Up to date
Web Server Software Microsoft-IIS/10.0
MySQL Version 5.5.45
PHP Version 7.4.1

a month later

Just updated to 1.15.1, and the closed tickets view is very slow. If you found a solution, would love to know. Otherwise, another vote for a fix!

9 months later

@kjo
Hi,

Did you find a solutions for your issue?

I migrated from CentOS8 to Debian 11 and everything works fine except loading 'closed tickets' . it takes up to 30 seconds now.
Thank you

Debian 11
OsTicket 1.14.7
Apache 2.4.48
MariaDB 10.5.11
PHP 7.4.21

Write a Reply...