"Nick Bowler" <nbowler_at_erols.com> wrote in message
news:91oomd$33q$1_at_autumn.news.rcn.net...
> I have been given this problem, and the DBA is out on vacation. Hopefully
> someone has had to deal with this before and can help.
>
> I have a large database (25 million records) on a AIX box.
> I need to archive and then delete about 5 million of the records.
> There are plenty of child records that also need to be archived and
deleted
>
> The archive program I inherited takes about 3 days to run -- way too long.
> However, it is logically correct. It opens a cursor on the main table for
> all records to archive / delete. For each record to be archived /
deleted,
> it finds all the children, then archives / deletes them. Finally, after a
> given number of records on the main table have been processed, it issues a
What is it written in? Make sure that it is using bind variables in the
select and delete statements. The overhead in reparsing adds up after
awhile.
Paul
Received on Tue Dec 19 2000 - 18:50:52 CST
