Connection over 2000 miles

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 Received on Fri Jul 27 2007 - 10:04:34 CDT