Subject RE: Balancing indexes
Author H. Th. van der Meer
Set,

Thank you for answering.

You said:
>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.

All the applications shut down at night, so there aren't any transactions
that last more the 24hrs.
In fact they are usually much much shorter.

About re-balancing, read:

http://www.ibphoenix.com/ibp_tip_perf.html
http://community.borland.com/article/0,1410,25471,00.html

So there is really such a thing as rebalancing.

Henk