Re: Connection over 2000 miles

dean wrote:
On Jul 27, 6:05 pm, DA Morgan <damor...@xxxxxxxxx> wrote:
dean wrote:
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
If you are caching 100 to 10K records and have the delay you reported
something is seriously wrong.
--
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 -

Wouldn't that depend on how many tables and records are opened and/or
loaded into memory? I will take a look and try to guess how many there
are and post here, but I know its a fair amount of data.

Not if you are caching a result set larger than what is being viewed by
the end user. Your theoretical refresh time of 60ms is less than the
time required to hit page-up/page-down.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

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
    ... 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: SD card and File System in WinCE 5....?
    ... Because when unload/reload SD client driver, ... So if App is running,suspend and then resume the system, if we unload and ... App will pop a message to notify user that the SD card is removed. ...
    (microsoft.public.windowsce.platbuilder)