>>Can you do a batch update updating 10K rows in a time? If each update is different. you can place the update of 10K rows into begin transaction / commit transaction to run it as a batch.
>
>Yes, I can do that. I was mostly wondering if this would be really a gain as far as optimization goes. Before doing code for that, I wanted to make sure the gain would be significant. If I only save a few fractions of a second on 10000 updates, then it would not be useful. But, if this round trip to the database server is a factor, I should see a significant improvement.
I think that the save is going to be significant, but it's up to you to test.
If it's not broken, fix it until it is.
My Blog