> I thought of something similar to that but I think both would be too slow.
> My tables can have 10 to 20 million records in them. I want to delete those
> that are over 2 months old but since there could be a million records to
> delete I want to delete them 100 at a time so the FB engine can process
> commands from other users on other databases.

A million on each day? Just do a day at a time?

Mine is not so bad in terms of numbers of records, but what
do is TIMESTAMP each new record as it is added, and then
just delete an hours worth at a time. I just keep 24 hours
worth of live data, and the rest goes into a history table
which just stores a shorter record for later reference. Only
hundreds of records, but the result is very fast.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services