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 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
