Page 1 of 1

Help: How to invoke stored procedure for batch update

Posted: Mon 02 Jul 2007 22:43
by rainfaith
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.

Posted: Tue 03 Jul 2007 13:43
by Challenger
Try to use CachedUpdates mode with the value of the UpdateBatchSize option more then 1. For more information please refer to ODAC help.

Posted: Thu 12 Jul 2007 08:28
by rainfaith
Thank you very much.