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

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/30/04 

Date: Fri, 29 Oct 2004 21:47:07 -0400

Hi Jiho,

I think you cannot compare Update and UpdateBatch for one reason. Update
updates data in a recordset, but UpdateBatch transfers all the updated data
to the database. When you call Updatebatch, it actually calls Update to
apply all the current changes to the recordset.
You could compare performance of the UpdateBatch and SQL statements, like
INSERT/UPDATE/DELETE 

-- 
Val Mazur
Microsoft MVP
"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

Relevant Pages