<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I'm using a SkipTransation callback in ShowHistory that does something like<div><br></div><div><div><%init></div><div> my $ttype;</div><div> $ttype = $Transaction->Type;</div><div> $$skip = 1 if (($_SkipSystemMessages) && ((($Transaction->Creator eq RT->Config->Get('SystemUserID')) </div><div>&& ($Transaction->Type ne 'Status') </div><div>&& ($Transaction->Type ne 'Comment')) || (($Transaction->Creator eq RT->Config->Get('CronUserID')) </div><div>&& (($Transaction->Type ne 'Give') </div><div>&& ($Transaction->Type ne 'Correspond'))) || ($Transaction->Type eq 'CustomField') || ($Transaction->Type eq 'Set' </div><div>&& $Transaction->Field eq 'TimeWorked')) );</div><div> my $type = $Transaction->Type;</div><div></%init></div><div><br></div><div>But I guess it's too late at this point for performance reasons, as we're already processing the entry?</div><div><br></div><div>Justin</div><div><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 12px;"><span class="Apple-style-span" style="font-size: medium;"><br></span></span></font></div><div><span class="Apple-style-span" style="font-size: 12px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>-------------------------------------------------</div><div>Justin Hayes</div><div>Orbis Support Manager</div><div><a href="mailto:justin.hayes@orbisuk.com">justin.hayes@orbisuk.com</a></div><div><br></div></div></span><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br><div><div>On 7 Jun 2010, at 21:53, Kenneth Marshall wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi Justin,<br><br>The last time I looked at this problem, the slow step is simply<br>preparing all of the transactions for the web. The biggest gains<br>were made by pruning the list of displayed transactions to the<br>bare minimum, by default. Then have a button to allow seeing<br>all of the transactions, if needed.<br><br>Regards,<br>Ken<br><br>On Thu, Jun 03, 2010 at 09:27:45AM +0100, Justin Hayes wrote:<br><blockquote type="cite">RT 3.8.4<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Does anyone have any suggestions on how to improve the time taken for RT to display ticket history. Depending on the number of entries on the ticket it can take 6-30seconds to render the ticket.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I've had a look in the mysql logs for slow queries and can't see any (though it's only logging ones that take longer than 1s so maybe it's doing lots and lots of faster ones that can still be optimised).<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I've put some debug logging in and all the time is going in ShowHistory, so I guess in the loop that loops over all the various transactions and things to display for that ticket.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Any suggestions or tweaks that people have done would be great, before I start investigating what's going on at a lower level.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thanks,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Justin<br></blockquote></div></blockquote></div><br></div></body></html>