Re: Batch rdoResultSet updates

RDO can not do a true batch update where one call is made after loading all of the rows to be sent. :-(

A very good RDO / Oracle resource is a book titled "Oracle Programming with Visual Basic" by Nick Snowdon (ISBN ISBN 0782123228).

If you were not limited to RDO, you could use Oracle Objects for OLE. It is the only way to do a batch update from VB6.

Then again...
You could pass the data to a your own C++ DLL that calls the Oracle OCI.DLL directly. This is not pretty solution though.

Zane E

rmaddock_at_my-deja.com wrote in message <7n9uu0$nlb$1_at_nnrp1.deja.com>...
>I've written some code in VB6 to send lots of individual rows via ODBC
>and RDO to and Oracle8 server on a remote machine.
>
>It is horribly slow and 90% of this seems to be network traffic.
>
>I believe that batch updates of rdoResultSets might be the answer to
>this. I've written a little test program which adds 10,000 new rows to
>a resultset and then does a batch update.
>However, watching the network from the server shows that the
>communication is constant through the whole loop, not just a big chunk
>at the end.
>
>Can anybody confirm the steps required to make this work properly?
>
>Alternatively, can anybody suggest a better way of doing it given that
>it must be via ODBC and RDO?
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sat Jul 24 1999 - 22:02:08 CDT