Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/VB and ODBC
We had horrible performance with Microsoft ODBC Driver for Oracle and we started using Oracle ODBC driver - the improvement in performance was incredible. Also investigate third party Oracle drivers like Intersolv, visigenic (although I think Microsoft ODBC driver for Oracle is based on Visisgenic).
Venkat
>We have a VB app that we currently use to access a back end Access JET
>database. Performance is adequate however, the locking mechanism in the
JET
>DB is terrible in multi user scenarios. Hence we have ported to Oracle
>using Microsoft's ODBC driver. Problem now is that performance is abysmal
>and I think it's all related to network traffic. Example, operation
>generates about 100 packets using JET DB engine yet same operation (just a
>select) generates over 20,000 network packets using Oracle ODBC! Anyone
>know if there are any tuning paramaters for this? Funny thing is that
>packet sizes for data are the same so it looks like there is some hugh
>overhead with the Oracle ODBC.
>
>Any help is much appreciated
>
>Cheers
>Dave
>
>Dave North
>Bay Networks
>dnorth_at_baynetworks.com
>
>
Received on Thu Apr 30 1998 - 00:00:00 CDT