Re: Oracle Performance
Date: 1998/12/15
Message-ID: <3676e9d9.4714256_at_newshost.interact.net.au>#1/1
On Tue, 15 Dec 1998 21:19:03 GMT, "Barbara Kennedy" <barbken_at_teleport.com> wrote:
>Drop the ODBC; very inefficient. Switch to the Oracle's OLE objects (more
>efficient) and read some of the pointers they give for performance.
>Also you need to determine what is slow (i.e. where is the bottleneck.) But
>having a lot of CPU usage is usually an indication of a lot of reparsing due
>to ODBC or badly formed queries.
Oh please. It's far more likely that VB, and badly written code are to blame than the ODBC driver. Other people have no problems writin fast ODBC apps. Also, using a 9600bps line is a joke! Think about what you're doing. You can get at most 1000 actual characters to pass over that line in one second, and that's before SQL*Net gets all chatty on you (which happens no matter what method you use!)
Ciao
Fuzzy
:-)
Received on Tue Dec 15 1998 - 00:00:00 CET