Re: Connection over 2000 miles

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1185550017.59095_at_bubbleator.drizzle.com...
> dean wrote:
>> Hello all,
>>
>> We are attempting to improve performance of a Windows app that
>> performs a fair amount of networking, loading up grids and tables,
>> opening data sources, etc. The database resides in Calgary, Canada,
>> while the app is based in Toronto, 2000 miles away. The responsiveness
>> of the app is not sooooo bad, one can scroll between rows of a
>> databound grid at 1 per second, but generally it needs to be sped up
>> or we'll have to go to some kind of remote access system and put the
>> app next to the server.
>>
>> So, I have two questions on if and how this process could be sped up:
>>
>> 1. Until now we have used the MS driver for Oracle, instead of the
>> Oracle driver for Oracle, since there were some issues with the oracle
>> driver. Over long distance, is there any advantage of using the Oracle
>> driver over the microsoft?
>>
>> 2. Either way, are there any parameters in the driver settings (such
>> as buffer size), that would be worth investigating for speed
>> improvement?
>>
>> We are using 10g 10.2.0.2.0, and the client uses ADO from a Borland
>> app on Windows XP.
>>
>> Thanks for any suggeestions.
>>
>> Dean
>
> Database version?
> What tool was used to create the front-end?
> Are records cached on the client? If not why not?
>
> The rule of thumb for delay is 1ms/33 miles so any delay significantly
> in excess of 60ms is an issue.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Daniel,

Interesting statistic. Where do you get that rule of thumb number from? I've never seen it before.

-- 
Terry Dykstra