Re: Slow response time
Re: Slow response time
- Subject: Re: Slow response time
- From: Ramsey Gurley <email@hidden>
- Date: Thu, 12 Sep 2013 09:19:22 -0700
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@hidden> 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@hidden]
>> Sent: Monday, September 09, 2013 8:45 AM
>> To: Beall, Mark (HPSL)
>> Cc: email@hidden
>> 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@hidden> 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@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden