[Rt-devel] Constantly updating attachments?

Jesse Vincent jesse at bestpractical.com
Fri Jan 14 14:21:24 EST 2005




On Fri, Jan 14, 2005 at 02:14:31PM -0500, David Kerry wrote:
> 
> 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)

> 
> -- 
> David Kerry
> 
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> 

-- 


More information about the Rt-devel mailing list