Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP ODBC DRIVER PERFOMANCE !SUPER URGENT
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