Batch rdoResultSet updates

From: <rmaddock_at_my-deja.com>
Date: Fri, 23 Jul 1999 14:41:06 GMT
Message-ID: <7n9uu0$nlb$1@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 Fri Jul 23 1999 - 09:41:06 CDT