Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: Connection over 2000 miles

Re: Connection over 2000 miles

From: DA Morgan <>
Date: Fri, 27 Jul 2007 15:05:22 -0700
Message-ID: <>

dean wrote:

> On Jul 27, 11:26 am, DA Morgan <> wrote:

>> 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, 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
>> (replace x with u to respond)
>> Puget Sound Oracle Users Hide quoted text -
>> - Show quoted text -
> All data loaded into databound components (such as grids) are cached,
> I believe. The CacheSize parameter in the data components (TADOQuery)
> is set to 100 to 10,000 in various different components.
> Version is mentioned above -
> Used Borland CBuilder 6

If you are caching 100 to 10K records and have the delay you reported something is seriously wrong.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Jul 27 2007 - 17:05:22 CDT

Original text of this message