[Rt-devel] Constantly updating attachments?

[David Kerry]

On Fri, Jan 14, 2005 at 02:21:24PM -0500, Jesse Vincent wrote:
> 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)

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

-- 
David Kerry