This is both a suggestion and a question if this approach is good or not.

Instead of deleting the records, how about recycling old records with an
Update. Only insert new records when there is no out-dated records
available.

Lester Caine wrote:

>>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.