Re: Commit problem

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

Commit at the end.


>From: "Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Commit problem
>Date: Mon, 22 Nov 1999 15:23:45 -0500
>
>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

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com