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