Subject | Re: [firebird-support] Re: One table become very slow |
---|---|
Author | Vlad Khorsun |
Post date | 2008-09-13T09:50:29Z |
> Sorry, i was wrong. Gstat finished though. Isn`t taht too much pagesYou have A LOT of unused backversions. It seems you have bad
> for 9400 records?
>
> CLIENTS (132)
> 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%
transaction control somewhere. The easiest you can do now to
improve things is to backup without garbage collection (gbak-g) and
restore.
Learn about transactions, versions and correct your application.
Regards,
Vlad