Indexing on columns in question? More memory for the database?
The typical DBA stuff... :) Sent from my iPad On Sep 12, 2013, at 8:42 AM, "Beall, Mark (HPSL)" <mark.be...@hp.com> wrote: > Thanks Ken, > I did turn on SQL debugging and the slow response is due to Database > latency. Are there any suggestions on ways this may be improved? > > > > From: Ken Anderson [mailto:kenli...@anderhome.com] > Sent: Monday, September 09, 2013 8:45 AM > To: Beall, Mark (HPSL) > Cc: webobjects-dev@lists.apple.com > Subject: Re: Slow response time > > Who don't you turn on SQL debugging to see how long queries are taking? > > On Sep 9, 2013, at 8:25 AM, "Beall, Mark (HPSL)" <mark.be...@hp.com> wrote: > > > Has anyone experienced slow application response time when running WebObjects > locally with a Juniper Network connection to an Oracle Database? > > Our application response time is fine when accessing applications in our > production, development and UAT environments via the web. It is only slow > when running locally during development(testing). By Comparison the > response time for accessing two pages from the same machine using the same > connections (Juniper VPN) are: > > Page one from IE. Response time is about 2 seconds > Page one from local run. Response time is about 22 seconds. > > Page two from IE. . Response time is about 3 seconds > Page tow from local run. Response time is about 1 minute 45 seconds. > > Are development environment is: > > Mountain Lion 10.8.4 > WebObjects 5.4.3 (No Project Wonder) > Eclipse Indigo > WOLips 3.6 > > Oracle Database 11.2 running on an HP servers. (remote site) > > Applications deployed on Mac min servers (remote site – same as DB servers)) > > Juniper Network Connect 7.1.10 > > We are using the Juniper VNP client to connect to remote site in both > instances (web access and local access). We have taken network captures > from one of our developers machines but are unable to see any problems so we > are not sure if the problem may reside in WebObjects, Eclipse, Wolips, > Juniper or the Network. > > > > Mark Beal > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com > > This email sent to kenli...@anderhome.com > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > > This email sent to p...@mac.com
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
