[rt-users] Performance issues when viewing tickets with attachments

[Mike White]

Hi all,

We've noticed that the time it takes to display a ticket after clicking 
on it is significantly greater when that ticket has one or more 
attachments in one item of correspondence.  (ie, 1 second vs. 6 seconds.)

Why would it need to grind away just to display a ticket?  Is there a 
solution for this?  Could it be that the Attachments table in the db is 
probably about 1.5 GB by now?

4000 ticket database, redhat 9, apache 1.3, FastCGI, mysql, RT 3.0.7_01.

By the way, switching to 3.0.7_01 and FastCGI totally fixed the 
attachment corruption issue for us, w00t.

Thanks for your help,
mike