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.
_____ From: Chris Nelson [mailto:[EMAIL PROTECTED] Sent: 28 November 2007 03:07 To: Daniel Jennings Cc: [email protected] Subject: Re: [rt-users] Merged tickets very slow We had this issue before. Are you using PostGres as your database? We found that once we vacuumed the database, it resolved the issue. Daniel Jennings wrote: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boris Lytochkin Sent: 24 November 2007 09:05 To: [EMAIL PROTECTED] Subject: Re: [rt-users] Merged tickets very slow I have seen them a lot too, even created small patch to mute them away: grep -i merged /rt/etc/RT_SiteConfig.pm Set($MuteWeFoundMergedTicket, "1"); 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? That sounds like a problem. I haven't seen that before. _____________ Boris Lytochkin, JSC e-port, Moscow _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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 [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
