[rt-users] Create.html very slow to load

[Myers, Adam]

Jesse,

I see there is a big change in Users_Overlay.pm for user rights lookup,
which is what I need. What are the other major areas of RT that has been
updated from 3.4.4. I have done a lot of custom additions and
modifications. I would like to upgrade but I am uneasy about it due to a
lot of files in ../local/lib and ../local/html that may have large
differences.

Thanks.


** Adam Myers

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Tuesday, November 29, 2005 2:07 PM
To: Myers, Adam
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Create.html very slow to load


On Tue, Nov 29, 2005 at 10:10:15AM -0700, Myers, Adam wrote:
>  
> >|< Reply to myself
>  
> I found that since I added all my companies users to the DB, the page 
> takes a long amount of time to run the 'SelectOwner' component.  It is
>  
> Is there a way to speed up this query? I can remove the option to
>  
> Please help

Can you try RT 3.4.5pre1? It contains a fix designed to address this
issue.

>  
> Adam
> 
> ________________________________
> 
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Myers, 
> Adam
> Sent: Tuesday, November 29, 2005 9:38 AM
> To: rt-users at lists.bestpractical.com
> Subject: [rt-users] Create.html very slow to load
> 
> 
> Hello,
>  
> I am running RT 3.4.4 on Solaris 10, Apache 1.3.34 w/mod_perl, Oracle
9.
>  
> I recently released RT into production and all is well, except now 
> when I select a queue and click to create a new ticket, RT hangs for a

> while and does not load "Create.html" for about 30 seconds.  My 
> development version does not do this so the only reason I can think of

> is the database backend.  This is the only difference between prod and
dev.
>  
> I am in a bind because my dev/test box works great, and I can't shut 
> down production to debug.  I have 18 queues in the DB and all other 
> pages that have to do with loading from the queues table loads fine.
>  
> Any ideas would be very helpful.
>  
> Thanks - Adam Myers
>  

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at

> http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and 
> San Francisco - Find out more at 
> http://bestpractical.com/services/training.html

--