Update multiple records at once
Posted on 2008-06-23
I need to update multiple records at once. For example:
UPDATE T1 SET Balance = 10 WHERE AccID = 5454;
UPDATE T1 SET Balance = 15 WHERE AccID = 5455;
I execute many (like 300+) of those updates at once. What I did is I put all of them into one command. But that's taking so long to execute. Is there any way to do it faster? I've seen it executes a lot of reads and some writes, so I think it spends most of the time finding each "AccID".