Constantly updating attachments?

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?

David Kerry

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?

If it sees at an attachment that doesn’t have a content-length header,
it fixes it. Are you seeing it update the same attachment multiple
times? (The content-length header is an important performance thing that
wasn’t always there)

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?

If it sees at an attachment that doesn’t have a content-length header,
it fixes it. Are you seeing it update the same attachment multiple
times? (The content-length header is an important performance thing that
wasn’t always there)

Ahh… no - this is only happening once per ticket, as intended then.

David Kerry