Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle/VB and ODBC
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 - 07:34:17 CDT
![]() |
![]() |