[rt-users] Slow Ticket History 3.8.8

Jason Doran Jason.Doran at nuim.ie
Tue Jun 29 10:22:16 EDT 2010

If you are using mysqld have a look at "mysqltuner.pl" perl script  
This has fixed quickly many performance issues on both RT and other
web-based software we use. I run this every few weeks and apply  
changes and then simply restart mysqld when things are quite.

Jason Doran
Computer Centre
NUI, Maynooth

On 29 Jun 2010, at 14:09, Justin Hayes wrote:

> Hi everyone,
> I've raised this before, but we've had another look at it and still  
> can't see how to improve things.
> We put a lot of comments/replies in our tickets. Often there can be  
> 50-100 entries in a ticket, mostly plain text. Loading such a ticket  
> can take 10-20secs.
> We don't have any slow queries - all the time seems to be in the  
> code rendering the history of the ticket.
> We've had a go at stripping functions out of ShowHistory,  
> ShowTransaction and ShowTransactionAttachmments but not had much  
> success.
> FWIW our RT runs on quad 3ghz Xeons with 8gb of ram.
> I'd like to try and determine if we're just slow, or if this is just  
> how long RT takes. Maybe perl is just slow.
> Can anyone shed any light on how long it takes them to render long  
> tickets in their systems? If you look at the page source it gives  
> you a value e.g.
> <span>Time to display: 24.996907</span>
> Can anyone share some numbers from theirs for longer tickets? It  
> would be really appreciated.
> Thanks,
> Justin
> -------------------------------------------------
> Justin Hayes
> OpenBet Support Manager
> justin.hayes at openbet.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com

More information about the rt-users mailing list