Re: HELP ODBC ORACLE DRIVER PERFOMANCE !SUPER URGENT

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 11 Aug 1998 11:46:02 GMT
Message-ID: <35d1c45a.2528870@netnews.worldnet.att.net>

On 8 Aug 98 20:57:42 GMT, "jeff oxenhandler" <jeffoxen_at_jps.net> wrote:

>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,.
Are you using RDO or DAO? DAO are the original data access objects that came w/VB. DAO uses the JET engine (same as Access), which adds a lot of overhead. RDO = Remote data objects, and should give you a performance boost over DAO. At least I found that to be the case for one application with slow connect time. Switching from DAO to RDO reduced the connection time from 30-40 seconds to only a second or two. You have to have VB5 Enterprise version, and you have to be developing for a 32-bit platform, to use RDO.

Hope this helps.

Jonathan Received on Tue Aug 11 1998 - 06:46:02 CDT