[rt-users] Merged tickets very slow

[Daniel Jennings]

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:cnelson at nighthawkrad.net] 
Sent: 28 November 2007 03:07
To: Daniel Jennings
Cc: rt-users at lists.bestpractical.com
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: rt-users-bounces at lists.bestpractical.com

[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Boris

Lytochkin

Sent: 24 November 2007 09:05

To: rt-users-request at lists.bestpractical.com

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 sales at bestpractical.com or call us at +1 617 812 0745.





Community help: http://wiki.bestpractical.com Commercial support:

sales at bestpractical.com





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 sales at bestpractical.com or call us at +1 617 812 0745.





Community help: http://wiki.bestpractical.com

Commercial support: sales at bestpractical.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/20071129/9d67a063/attachment.htm>