Re: [SQL] Commiting after certain no of rows have been deleted

2005-12-21 Thread Richard Huxton
Smita Mahadik wrote: Hi, In my application I m deleteing large no of rows from table based on certain condition. This takes lot of time and if sometimes my application fails it starts all over again...since the coomit is done at the end of transactions. Is there a way i can do commit when certai

[SQL] Commiting after certain no of rows have been deleted

2005-12-20 Thread Smita Mahadik
Hi,   In my application I m deleteing large no of rows from table based on certain condition. This takes lot of time and if sometimes my application fails it starts all over again...since the coomit is done at the end of transactions. Is there a way i can do commit when certain no o