Re: VB/OO4O ACCESS to ORACLE DB

Some of that also depends on whose drivers you are using. Try your timing runs again with the Openlink drivers. (available in a try before you buy version on compuserve) I found them to be faster than Microsoft and Oracles. Also please remember that basically all that a driver does is translate a high order request into API calls. Put a trace on the driver sometime, if you want to see exactly what is sent. Also, alot of other things can impact your timings such as an optimized network. Check your packet size. Most nets default to a much smaller packet than the net/ oracle can handle. Upping the size increase the throughput in a given amount of time, and gives better results.

Also, you didn't state if this was an update set, or a report format. If a read-only situation, look at how you are bringing in the data:: Snapshop or full recordset, one is significantly faster than the other for display purposes.

Richard Clapp
Columbus, OH
102777.3306_at_compuserve.com Received on Thu May 16 1996 - 00:00:00 CEST