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

[Jesse Vincent]

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

--