[rt-users] Slow Ticket History 3.8.8

[Charles Johnson]

Quite outside of the speed of RT, what database are you using as a  
back-end? How long has it been since you did some care and feeding of  
your database? How big are your tables? If you are using mysql or  
postgres have you used their tools to examine your database,  
especially the indexes and statistics? This may be an issue with  
indexes needing to be rebuilt, or asking the database to gather new  
statistics for the queries your are running.

Cheers--

Charles

On Jun 29, 2010, at 8:09 AM, 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

--
Charles Johnson, Vanderbilt University
Advanced Computing Center for Research & Education
Mailing Address:  Peabody #34, 230 Appleton Place, Nashville, TN 37203
Shipping Address: 1231 18th Avenue South, Hill Center, Suite 143,  
Nashville, TN 37212
Office: 615-343-4134
Cell: 615-478-5743
Fax: 615-343-7216
charles.johnson at accre.vanderbilt.edu