Re: Performance comparison on Update vs. UpdateBatch - record by record

From: Michael D. Long (michael.d.long-nospam_at_comcast.net)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 14:11:38 -0400

Why not test it. Perform a benchmark of 500,000 rows using .Update against
the same data set using .UpdateBatch and look at the difference. Make
certain to start with an identical blank database in each case, and to
ensure that machine resources are in the same state (a reboot of the
machine(s) involved prior to each test is a good idea).

I would put forth the hypothesis that .UpdateBatch incurs more overhead on a
single row update and will be marginally slower in your use proposed
scenario. 

-- 
Michael D. Long
"Jiho Han" <jhan@infinityinfo.com> wrote in message 
news:uOdehZPvEHA.1300@TK2MSFTNGP14.phx.gbl...
>I was wondering if there are any significant performance difference between 
>using Update vs. UpdateBatch (adLockOptimistic vs. adLockBatchOptimistic).
>
> I don't mean to batch up changes and call UpdateBatch.  I would be calling 
> UpdateBatch on every record change basically.
> I know I could simply use Update in this case but that's not the point.
>
> Thanks much.
> Jiho