jamesarm97 wrote:

> I have a firebird database with many tables. I have a purge utility
> that saves old records to a file, then deletes them. There is a table
> that has not been part of this process and has grown to > 2.6 million
> records. ...
>
> This takes a good bit of time to delete all the records. If I try a
> database backup after that it hangs on that table. I database
> validation also takes does not complete or if it does takes forever
> (ran overnight). Is it a database sweep problem?

Yes. First deactivate all the indexes on the table, then backup
or sweep the database or just count the records in the table.


Regards,


Ann