Re: HELP ODBC ORACLE DRIVER PERFOMANCE !SUPER URGENT

From: John Mason Jr <masonj_at_erols.com>
Date: Wed, 12 Aug 1998 21:08:40 -0400
Message-ID: <6qteek$6ug$1@winter.news.erols.com>

Hi Jeff,

Thought I would add my two cents (Mostly Access frontend/oracle backend experience)Is the query a pass through, some queries using the Jet engine cause processing to occur locally instead of on the server.

John
jeff oxenhandler wrote in message <01bca3d9$5a015a00$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 Wed Aug 12 1998 - 20:08:40 CDT