Re: Connection over 2000 miles

From: dean <deanbrown3d_at_yahoo.com>
Date: Tue, 31 Jul 2007 00:41:18 -0000
Message-ID: <1185842478.772013.247410@r34g2000hsd.googlegroups.com>

On Jul 27, 9:27 pm, DA Morgan <damor..._at_psoug.org> wrote:
> dean wrote:
> > 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-Hidequoted 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.

>

> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

Our datagrids are from TopGrid, and as yet I don't know of any way to say to it to load up only what is currently visible on the screen. With in-memory grids, that's simple of course, but not with this datagrid. I will check the groups though to see if there is an answer, though I think we have looked in the past.

Some speed testing tomorrow...

Thanks Daniel,

Dean Received on Mon Jul 30 2007 - 19:41:18 CDT