Subject Re: [ib-support] large deletions
Author Ann W. Harrison
At 10:15 AM 7/2/2002 -0400, Bob Lazarchik wrote:

>I have a log database used in manufacturing tools that creates up to
>100,000 - 200,000 entries daily. I need to clean out records that are
>more than 8 days old on a daily basis and I am looking for some ideas on
>how to do this.

Rather than throwing out a day's worth every day, can you throw out
an hour's worth every hour? Or a minute's worth every minute? A more
frequent smaller delete may have less impact than a single huge delete.

Are there any times of the day when the load is below average? Could
you do a series of smaller deletes during that time?

What indexes do you have on that table? Do any of them have large
numbers of duplicates? If so, find a way to make those indexes closer
to unique - like making a compound index with the desired key first
and the primary key second. Index garbage collection is not your
friend in this application.


We have answers.