Thanks Samuel and Ramsey for your responses. We do have a large data base so copying the data base is not a good option for us. I will check into the prefetch option. I know we use it but maybe not in all instances.
-----Original Message----- From: Ramsey Gurley [mailto:[email protected]] Sent: Thursday, September 12, 2013 12:19 PM To: Beall, Mark (HPSL) Cc: [email protected] Development Subject: Re: Slow response time On Sep 12, 2013, at 7:32 AM, Samuel Pelletier wrote: > Mark, > > The only solution is to run the app on the same networks as the database > server. Data gravity :-) http://readwrite.com/2012/05/07/what-data-gravity-means-to-your-data Latency numbers every programmer should know: https://gist.github.com/jboner/2841832 Round trip within same datacenter 500,000 ns 0.5 ms Send packet CA->Netherlands->CA 150,000,000 ns 150 ms Reduce the round trips by prefetching and/or restructure your data. Not only will you be able to use the remote connection, but it will greatly improve the performance of you app on the server too. If you've done all the prefetching and data restructuring possible, then yeah, do what Samuel said. > 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%40and >> erhome.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%40samka >> r.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/rgurley%40smart > health.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]
