RE: Slow response time
RE: Slow response time
- Subject: RE: Slow response time
- From: "Beall, Mark (HPSL)" <email@hidden>
- Date: Thu, 12 Sep 2013 17:12:13 +0000
- Thread-topic: Slow response time
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@hidden]
Sent: Thursday, September 12, 2013 12:19 PM
To: Beall, Mark (HPSL)
Cc: email@hidden 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@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:
>> erhome.com
>>
>> 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:
>> r.com
>>
>> 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:
> health.com
>
> 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