| Subject | RE: [firebird-support] Re: One table become very slow |
|---|---|
| Author | Leyne, Sean |
| Post date | 2008-09-12T22:15:57Z |
> CLIENTS (132)There's your problem!
> Primary pointer page: 207, Index root page: 208
> Average record length: 288.79, total records: 9403
> Average version length: 9.00, total versions: 27565987, max
> versions: 6180
> Data pages: 209068, data page slots: 209849, average fill: 86%
...total versions: 27565987 !!!, max versions: 6180!!!
What does the initial database header stats look like (Oldest
Transaction, Oldest Active Transaction...)?
Sean