Joe, Turn on client side SQL logs and active link logs. Watch for workflow that is triggered after submit or after modify, such as the way the older Help Desk would replace a GUID with an case number, or looking for a certain email message to update some text and change the status to Send it out. Chances are you'll find a full table scan or two in there which you can fix with an index.
At one client site I found the email replace text issue was looking at every email subject line for the current ticket number. The AR System Email Messages form had/has no indexing by default, and someone disabled the escalation that removed the old messages. Submitting every help desk ticket caused a scan of several hundred thousand onld emails :-) hth Doug ___ Doug Blair Remedy Skilled Professional doug<at>blairing<dot>com +1-224-558-5462 ...... Original Message ....... On Fri, 30 Mar 2007 13:01:13 -0400 "Soria, Joe" <[EMAIL PROTECTED]> wrote: >Listers, > >I am baffled here and need some guidance. > >We are running ARS 6.3 patch 20 on solaris. The user community experiences extreme slowness when submitting on any form. We have verified that there is no latency on our network, we have also verified that our database is performing at a very good rate. Our app server and db server reside on the same subnet. I have performed client side logging, as well as filter/sql/api logging. Both our app server and db server are experience low load on both cpu & memory. I am not seeing any significant load of transactions nor have I been able to isolate the slowness. I have rtfm and am coming to you as a last resort (before calling support, argh). Any ideas on troubleshooting this is greatly appreciated. > >Joe > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
