Re: Connection over 2000 miles

On Jul 27, 11:26 am, DA Morgan <damor...@xxxxxxxxx> 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 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
damor...@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org- 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 - 10.2.0.2.0
Used Borland CBuilder 6

.

Relevant Pages

  • Re: Connection over 2000 miles
    ... performs a fair amount of networking, loading up grids and tables, ... while the app is based in Toronto, ... Oracle driver for Oracle, since there were some issues with the oracle ...
    (comp.databases.oracle.misc)
  • Re: Connection over 2000 miles
    ... performs a fair amount of networking, loading up grids and tables, ... while the app is based in Toronto, ... Oracle driver for Oracle, since there were some issues with the oracle ...
    (comp.databases.oracle.misc)
  • Re: Connection over 2000 miles
    ... performs a fair amount of networking, loading up grids and tables, ... while the app is based in Toronto, ... Oracle driver for Oracle, since there were some issues with the oracle ...
    (comp.databases.oracle.misc)
  • Re: Connection over 2000 miles
    ... performs a fair amount of networking, loading up grids and tables, ... while the app is based in Toronto, ... Oracle driver for Oracle, since there were some issues with the oracle ...
    (comp.databases.oracle.misc)
  • Connecting to ODBC DB at startup
    ... Oracle tables in the table list, it asks for an id and pass. ... The problem is when I go to run a query or do anything else in the app ... Dim cnConn As ADODB.Connection ... Dim strLogin As String ...
    (comp.databases.ms-access)