osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Long query and page loading
I'm working on making sure our upgrade works successfully. One thing I've noticed on the latest version is that clicking into / out of tickets causes a query to be initiated that takes about a minute to finish (sometimes more). Jumping out and into another ticket seems to be fine, and this seems to not slow anything down.
The query is:
-- Command: Query
-- Time: 13 (at time of snap)
-- State: Sending data
SELECT A1.`id`, A1.`title`, A1.`body`, A1.`format` FROM `ost_ticket_thread` A1
LEFT JOIN `ost__search` A2 ON (A1.`id` = A2.`object_id` AND A2.`object_type`='H')
WHERE A2.`object_id` IS NULL AND (A1.poster <> 'SYSTEM')
AND (LENGTH(A1.`title`) + LENGTH(A1.`body`) > 0)
ORDER BY A1.`id` DESC
Again, I'm not sure this is affecting anything other than showing the spinning "loading" wheel in the internet browser's tab... is this an issue or not something I should be worried about? Does this have anything to do with attachments?