Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connection over 2000 miles
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_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Jul 27 2007 - 10:26:59 CDT