>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.