RE: Runtime for deleteing lots of records

[ouuch@xxxxxxxxxxx]

Vern,

On 10 Feb 2003 at 8:48, Vern Hamberg wrote:
> The other points, esp. about copying the records you want to keep and
> clearing the file, are right on, IMO, esp. when the number of deleted
> records will be most of the file. You can CPYF on a range, and an
> existing logical will help this, too. You deleted c.72% of the
> records. Copying the other 28% would mean, at worst, about 40% of the
> I/O, and could be better, if blocking can be used - deletes are not
> blocked.
> 
> In my experience, SQL is the worst tool for deleting records, esp. a
> lot of them, relatively speaking. It's awfully easy to program but
> often performs very badly. The usual trade-off is: Convenient for the
> programmer, bad for the user (or performance).

we only run this SQL every other year or so.. And luckily, weekends are free 
for this kind 
of stuff.

I was just a little surprised about the long runtime.

How long will the RGZPFM take?

Regards,

Oliver