Subject Re: [ib-support] Balancing indexes
Author Svein Erling Tysvær
>We have an application that uses generated (sequential) numbers as primary
>keys. We have noticed that the application slows down after a while. We have
>also noticed that it returns to full speed when we perform a backup/restore.
>We assume this is because the indexes are re-balanced. We need to do this
>once a week.


I have never heard about re-balancing anything in Interbase and would be
very surprised if this was your problem. What is more likely is that you
have open (long-running) transactions somewhere requiring the database to
keep lots of old record versions. Try to find out how far the oldest active
transaction (OAT) is from the next transaction.

Thinking about it, that doesn't sound likely either as it should have
advanced by simply stopping and restarting the server without any backup.
Maybe you need some garbage collection? Try doing a sweep.