"Allan, Mark" <[EMAIL PROTECTED]> wrote: > Thanks for your quick reply. > > > You can use a SELECT to count the number of records to be > > deleted. Then start your progress bar and do separate > > SQL statements to delete each record one-by-one, updating > > your progress bar as you go. > > I thought of this but am sure that doing this way is a lot slower on = > performance than doing all within a single transaction (i.e. BEGIN, = > COMMIT). Am I correct in this assumption? >
Yes. To get reasonable performance you will need to enclose the SELECT and all the individual DELETEs within a BEGIN...COMMIT. -- D. Richard Hipp <[EMAIL PROTECTED]>
