Mark, The only solution is to run the app on the same networks as the database server. You may either create a copy of the database on your dev location or remote debug the test app on a machine at the database location.
The database copy on the dev location is way better but may be complex to implement in a large company (server admin and DBA will probably need to be involved) If your database is simple, you may try to copy the schema and data on a FrontBase / mySQL / PostgreSQL local database. Those are way easier to install and manage, prefer PostgreSQL or FrontBase they are more like Oracle that mySQL. Samuel Le 2013-09-12 à 08:42, "Beall, Mark (HPSL)" <[email protected]> a écrit : > 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:[email protected]] > Sent: Monday, September 09, 2013 8:45 AM > To: Beall, Mark (HPSL) > Cc: [email protected] > 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)" <[email protected]> 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 ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.com > > This email sent to [email protected] > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
