<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#000080
size=2></FONT> </DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080
size=2>>|< Reply to myself</FONT></SPAN></DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080 size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080 size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080 size=2>Please
help</FONT></SPAN></DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=164040317-29112005><FONT face=Arial color=#000080
size=2>Adam</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Myers,
Adam<BR><B>Sent:</B> Tuesday, November 29, 2005 9:38 AM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> [rt-users] Create.html very
slow to load<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial
size=2>Hello,</FONT></SPAN></DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial size=2>I am running RT
3.4.4 on Solaris 10, Apache 1.3.34 w/mod_perl, Oracle 9.</FONT></SPAN></DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial size=2>Any ideas would be
very helpful.</FONT></SPAN></DIV>
<DIV><SPAN class=687421116-29112005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV align=left>
<DIV align=left><FONT face=Arial><FONT size=2><SPAN
class=687421116-29112005>Thanks - </SPAN>Adam Myers</FONT></FONT></DIV></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>