Help: How to invoke stored procedure for batch update

rainfaith · Post by **rainfaith** » Mon 02 Jul 2007 22:43

I have a list of records to update or insert into db via stored procedure, and because the delay of network flow is a bit high, I want to invoke the stored procedure for batch update, how to implement this?

Thank you for your help.

Challenger · Post by **Challenger** » Tue 03 Jul 2007 13:43

Try to use CachedUpdates mode with the value of the UpdateBatchSize option more then 1. For more information please refer to ODAC help.

rainfaith · Post by **rainfaith** » Thu 12 Jul 2007 08:28

Thank you very much.