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

[Myers, Adam]

That is what's bewildering me right now is that all users are brand new
and are not apart of any group or have any rights granted. There are
only about 15 users right now that have the right to own a ticket.


** Adam Myers

-----Original Message-----
From: Drew Barnes [mailto:barnesaw at ucrwcu.rwc.uc.edu] 
Sent: Tuesday, November 29, 2005 10:13 AM
To: Myers, Adam
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Create.html very slow to load



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