I’ve been looking at the sql queries RT has been using to see if some
operations can be sped up… anyway, I discovered this one that
popped out when viewing an individual ticket:
SELECT content FROM Attachments WHERE id = ‘279982’;
followed immediately after by this:
UPDATE Attachments SET Headers= ‘…’ WHERE id= ‘279982’;
This seems a little odd - RT updates the attachments on a ticket even
when I’m just viewing it?