<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16546" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=076165910-29112007>Vacuuming the database doesn't and wouldn't sort this
out. Its not an issue of slow database access, its that its running the 'merged
ticket code' more then 6000 times. The ticket has 12 merges and over 100
replies.</SPAN></FONT></DIV><FONT face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Chris Nelson
[mailto:cnelson@nighthawkrad.net] <BR><B>Sent:</B> 28 November 2007
03:07<BR><B>To:</B> Daniel Jennings<BR><B>Cc:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> Re: [rt-users] Merged
tickets very slow<BR></FONT><BR></DIV>
<DIV></DIV><BIG>We had this issue before. Are you using PostGres as your
database? We found that once we vacuumed the database, it resolved the
issue.<BR><BR></BIG>Daniel Jennings wrote:
<BLOCKQUOTE cite=mid:3AFD20617C0243AF986F5B02DB27EAAF@VistaPC type="cite"><PRE wrap="">The issue isn't really the output, its the 30 to 40 seconds it takes to load
the ticket. I guess though it maybe nice not to see it fill up the log all
the itme.
-----Original Message-----
From: <A class=moz-txt-link-abbreviated href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</A>
[<A class=moz-txt-link-freetext href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</A>] On Behalf Of Boris
Lytochkin
Sent: 24 November 2007 09:05
To: <A class=moz-txt-link-abbreviated href="mailto:rt-users-request@lists.bestpractical.com">rt-users-request@lists.bestpractical.com</A>
Subject: Re: [rt-users] Merged tickets very slow
I have seen them a lot too, even created small patch to mute them away:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">grep -i merged /rt/etc/RT_SiteConfig.pm
</PRE></BLOCKQUOTE><PRE wrap=""><!---->Set($MuteWeFoundMergedTicket, "1");
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">Hi,
We have an issue with merged tickets taking a very long time to load,
up to 30 seconds. The sub TicketOverloay::Load is called a lot,
logging 6000 lines of 'found merged ticket'.
Is this just how it works or is there a problem here?
</PRE></BLOCKQUOTE><PRE wrap="">That sounds like a problem. I haven't seen that before.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
_____________
Boris Lytochkin,
JSC e-port, Moscow
_______________________________________________
<A class=moz-txt-link-freetext href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A>
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch
today.
Email us at <A class=moz-txt-link-abbreviated href="mailto:sales@bestpractical.com">sales@bestpractical.com</A> or call us at +1 617 812 0745.
Community help: <A class=moz-txt-link-freetext href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A> Commercial support:
<A class=moz-txt-link-abbreviated href="mailto:sales@bestpractical.com">sales@bestpractical.com</A>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <A class=moz-txt-link-freetext href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A>
_______________________________________________
<A class=moz-txt-link-freetext href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A>
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today.
Email us at <A class=moz-txt-link-abbreviated href="mailto:sales@bestpractical.com">sales@bestpractical.com</A> or call us at +1 617 812 0745.
Community help: <A class=moz-txt-link-freetext href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A>
Commercial support: <A class=moz-txt-link-abbreviated href="mailto:sales@bestpractical.com">sales@bestpractical.com</A>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <A class=moz-txt-link-freetext href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A>
</PRE></BLOCKQUOTE><BR></BODY></HTML>