Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle/VB and ODBC

Oracle/VB and ODBC

From: Dave North <dnorth_at_baynetworks.com>
Date: Thu, 30 Apr 1998 08:34:17 -0400
Message-ID: <6i9r5a$pjj$1@paperboy.baynetworks.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US