On Jul 27, 6:05 pm, DA Morgan <damor..._at_psoug.org> wrote:
> dean wrote:
> > On Jul 27, 11:26 am, DA Morgan <damor..._at_psoug.org> 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..._at_x.washington.edu (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..._at_x.washington.edu (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.
Received on Fri Jul 27 2007 - 17:29:32 CDT
