[rt-users] Slow Ticket History 3.8.8

[Kenneth Marshall]

On Thu, Jul 01, 2010 at 02:30:56PM +0100, Justin Hayes wrote:
> Hi Roy,
> 
> We've logged the SQL statements on the test server - virtually every query is .000s of a second. Yet the ticket we're using on there still takes 12s to render.
> 
> So the queries seem ok. However I know that having a huge ticket in a small DB is much faster (say 2s). So it *seems* to be DB or server related, I just don't know how...
> 
> Thanks,
> 
> Justin
> 

Wild conjecture: The time is spent grabbing the attachments from
the database. For the small database, all of them are available
in just a few reads. For the large database, each attachment or
update will need to have its own seek/read and will not typically
be cached.

Cheers,
Ken