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

[Myers, Adam]

>|< 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.
 
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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051129/ba1c038d/attachment.htm>