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 MyersFrom: Drew Barnes [mailto:email@example.com]
Sent: Tuesday, November 29, 2005 10:13 AM
To: Myers, Adam
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.
[mailto:firstname.lastname@example.org] *On Behalf Of
Sent: Tuesday, November 29, 2005 9:38 AM
Subject: [rt-users] Create.html very slow to load
I am running RT 3.4.4 on Solaris 10, Apache 1.3.34 w/mod_perl, Oracle
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
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
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
WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
Raymond Walters College
University of Cincinnati