OrWolf
MIS
- Mar 19, 2001
- 291
I have a stored procedure that needs to process some 1.3 million records. So that the transaction log doesn't fill up can how can I commit each record as the update SQL statement is given?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Commit Individual Transactions
- Thread starter OrWolf
- Start date
- Status
You don't want to run each individual record becasue that will take too much processing time, you want to run batches. Look at this FAQ
How to Use Batch Size to Speed Mass Updates, Inserts and Deletes faq183-3141
Questions about posting. See faq183-874
Click here to help with Hurricane Relief
How to Use Batch Size to Speed Mass Updates, Inserts and Deletes faq183-3141
Questions about posting. See faq183-874
Click here to help with Hurricane Relief
- Status
Similar threads
- Locked
- Question