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

[Drew Barnes]

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 
> querying to see WhoHasRight to own a ticket in that queue.  This 
> searches only 378 users, so every time that component is called it 
> will take about 20-30 seconds to load.

Do all 378 users need to OWN tickets, or just be requestors?  That's the 
quickest way to prune the load time.

>  
> Is there a way to speed up this query? I can remove the option to 
> SelectOwner on ticket creation, not many people do that anyways. But 
> when a ticket needs a watcher or owner assigned, it will hang for a 
> while which is not good.
>  
> Please help
>  
> 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

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati