[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Commit problem

Dan,
I always subscribe to the 'all or none' theory thus, I prefer doing a commit at the end.  If the program ever aborts prematurely, at least I know where I have to pick up from, every time....the beginning.
Sam

<<< "Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM> 11/22  3:23p >>>
Hi
  Here is a question to all the sqr gurus out there.
I am processing 10,000 records in a begin select loop. I need to update the
records as I read them. When is the best time to commit
1.      After each row is updated
2.      After 1000 rows
3.      At the end

your thoughts are highly appreciated
Thanks
Dan Johnson