Subject | RE: Balancing indexes |
---|---|
Author | H. Th. van der Meer |
Post date | 2001-08-02T13:45:38Z |
Set,
Thank you for answering.
You said:
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
Thank you for answering.
You said:
>I have never heard about re-balancing anything in Interbase and would beAll the applications shut down at night, so there aren't any transactions
>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.
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