Re: Connection over 2000 miles

"DA Morgan" <damorgan@xxxxxxxxx> wrote in message
news:1185550017.59095@xxxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx (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


.

Relevant Pages

  • Re: Connection over 2000 miles
    ... while the app is based in Toronto, ... Oracle driver for Oracle, since there were some issues with the oracle ... All data loaded into databound components (such as grids) are cached, ... Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text - ...
    (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
    ... opening data sources, etc. ... 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
    ... The database resides in Calgary, Canada, ... while the app is based in Toronto, ... Oracle driver for Oracle, since there were some issues with the oracle ... All data loaded into databound components (such as grids) are cached, ...
    (comp.databases.oracle.misc)