Hi,
I need t loop through 10 million records and do some math on on some values and post result to a field (Same table).

It works fine..

I do this with 2 queries..One to loop, one to update etc.

I am

1. Committing the transaction every 1000 records for performance.
2. Turn on the UniDirectional property to use less memory.


Is there any sort of buffering that I can set to increase performance?
The whole process takes about 2 hours, Id like to try to improve that as I have to run it about once a week.



[Non-text portions of this message have been removed]