[rt-users] Slow Ticket History 3.8.8

[Justin Hayes]

Thanks Jason - I'll give that a go as well. We have got a large DB (~10gb) so keeping it tuned is definitely important.

However as stated the time seems to be lost in code, after I'd have thought it had run the query for the ticket (though I may be wrong in that assumption).

Cheers,

Justin

-------------------------------------------------
Justin Hayes
OpenBet Support Manager
justin.hayes at openbet.com

On 29 Jun 2010, at 15:22, Jason Doran wrote:

> Hi,
> If you are using mysqld have a look at "mysqltuner.pl" perl script (google)
> 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 suggested
> changes and then simply restart mysqld when things are quite.
> 
> Regards,
> 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
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100629/decac58c/attachment.htm>