Re: HELP ODBC DRIVER PERFOMANCE !URGENT

You could use the native Oracle API (OCI, Oracle Call Interface) for direct, no guessing performances..

For the OCX for OCI check SQL-Sombrero/OCX for OCI at: http://www.sfi-software.com/ under the "products" section.

"Visual Basic Programmer's Journal Reader's Choice Award 1997" "SQL-Sombrero/OCX: "SQL-Sombrero continues to deliver something hard to find in many other products: it works, it's fast and it's reliable" VBPJ.
Hope this will help.

Sylvain Faust
President
Sylvain Faust Intl (SFI)
880 boul. de la Carrière, Suite 130
Hull, Québec, Canada J8Y 6T5

Tel: (819) 778-5045, Ext. 804
Toll Free: 1-800-567-9127 ( U.S. and Canada only) Fax: (819) 778-7943 International; (617) 722-9389 U.S. only Email: sfaust_at_sfi-software.com

Sylvain Faust Inc. (SFI)
A Decade of Delivering SQL Solutions, 1988-1998 http://www.sfi-software.com

To receive news bulletins from SFI automatically, just send a blank email to:
> SFI-NEWS-SUBSCRIBE-REQUEST_at_peach.ease.lsoft.com
 

> -----Original Message-----
> From: jeff oxenhandler [SMTP:jeffoxen_at_jps.net]
> Posted At: Saturday, August 08, 1998 4:59 PM
> Posted To: tools
> Conversation: HELP ODBC DRIVER PERFOMANCE !URGENT
> Subject: HELP ODBC DRIVER PERFOMANCE !URGENT
>
> 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 Mon Aug 10 1998 - 15:56:53 CEST