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 -> Re: HELP ODBC DRIVER PERFOMANCE !SUPER URGENT

Re: HELP ODBC DRIVER PERFOMANCE !SUPER URGENT

From: Carl Tierney <carltierney_at_email.msn.com>
Date: Sun, 9 Aug 1998 18:33:49 -0400
Message-ID: <OjzWTb#w9GA.277@upnetnews03>


If you are using dynasets in your VB code, you should switch to execute statements.

jeff oxenhandler wrote in message <01bca3d9$74c17f00$6ac5efd1_at_default>...
>Hi,valued VB and DB Guru
>
>My environment
>network Novell Netware 4.1
>Oracle Server 7.3.4 on NT box
>Client:
>Oracle ODBC Driver Oracle 7.3 Ver 2.5 2.05.0301,Win 95,
>MS Driver Manager and other ODBC stuff 3.0.28.22
>Aplication in VB for SQL statement execution ODBC based
>
>Result
>the script (1000 Inserts) takes two times more time with VB application
>than the same script executed in SQL*PLUS environment on the same
>WORKSTATION,.
>Has anyone have the same expirience?
>
>Any ideas?
>
>Thanks in advance
>mailto :jeffoxen_at_jps.net,
>
>Jeff Oxenhandler
>
>
Received on Sun Aug 09 1998 - 17:33:49 CDT

Original text of this message

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