Re: How to connect FAST to Oracle from Visual Basic app ?!

Ad Gerrits wrote:

> I want to retrieve a just a little bit of data from an Oracle database via a
> Visual Basic application. I want to do this as fast as possible because it
> has to be done a number of times each day by a number of users.
> I managed to do it by writing a temporary Odbc datasourcename to the
> registry and then use it to connect to Oracle via Dao/Odbc. It works....
> but is awfully making the connection. Because I use the connection only for
> 1 small query this is not acceptable.
> Who knows a faster way to do this and can give some hints or example code on
> how to do it.
>
> Correct me if I'm wrong but:
> - as far as I know for Vb there is no "Oracle Call Interface" or
> Precompiler as for C.
> - Is OracleObject for Ole a good alternative and is it (much) faster ?
> - Should I migrate to Ado and use a native OleDb driver ?

Any method will have some overhead associated with making the connection happen (even OCI) and connecting intially tends to be expensive (time wise). OO4O might be the best performance, particlalry if you keep the InProc server alive (even if it is disconnected), then subsequent connections should be faster. Received on Tue Apr 27 1999 - 15:56:09 CEST