I would say that the best thing you can do is turn on all logging from the client and determine where the greatest gap in your processing is...is it between API and SQL for example. A log of a submit should help determine where those delays are occurring at
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Soria, Joe Sent: Friday, March 30, 2007 11:01 AM To: [email protected] Subject: Slow responses 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"
