<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks Jason - I'll give that a go as well. We have got a large DB (~10gb) so keeping it tuned is definitely important.<div><br></div><div>However as stated the time <b>seems</b> 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).</div><div><br></div><div>Cheers,</div><div><br></div><div>Justin<br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><br>-------------------------------------------------<br>Justin Hayes<br>OpenBet Support Manager<br><a href="mailto:justin.hayes@openbet.com">justin.hayes@openbet.com</a></span>
</div>
<br><div><div>On 29 Jun 2010, at 15:22, Jason Doran wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi,<br>If you are using mysqld have a look at "<a href="http://mysqltuner.pl">mysqltuner.pl</a>" perl script (google)<br>This has fixed quickly many performance issues on both RT and other<br>web-based software we use. I run this every few weeks and apply suggested<br>changes and then simply restart mysqld when things are quite.<br><br>Regards,<br>Jason Doran<br>Computer Centre<br>NUI, Maynooth<br><br>On 29 Jun 2010, at 14:09, Justin Hayes wrote:<br><br><blockquote type="cite">Hi everyone,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I've raised this before, but we've had another look at it and still can't see how to improve things.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">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.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">We don't have any slow queries - all the time seems to be in the code rendering the history of the ticket.<br></blockquote><blockquote type="cite">We've had a go at stripping functions out of ShowHistory, ShowTransaction and ShowTransactionAttachmments but not had much success.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">FWIW our RT runs on quad 3ghz Xeons with 8gb of ram.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">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.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">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.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><span>Time to display: 24.996907</span><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Can anyone share some numbers from theirs for longer tickets? It would be really appreciated.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thanks,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Justin<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">-------------------------------------------------<br></blockquote><blockquote type="cite">Justin Hayes<br></blockquote><blockquote type="cite">OpenBet Support Manager<br></blockquote><blockquote type="cite"><a href="mailto:justin.hayes@openbet.com">justin.hayes@openbet.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br></blockquote><blockquote type="cite">Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote><br></div></blockquote></div><br></div></body></html>