Subject Re: One table become very slow
Author marrtins_dqdp
What does it mean here total versions and max versions? Whats wrong
about that? How could it be fixed/avoided? Thank you for your help!

Header:

Database header page information:
Flags 0
Checksum 12345
Generation 44503
Page size 4096
ODS version 11.1
Oldest transaction 44493
Oldest active 44494
Oldest snapshot 44494
Next transaction 44495
Bumped transaction 1
Sequence number 0
Next attachment ID 12040
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Aug 25, 2008 21:57:39
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
> > 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%
>
> There's your problem!
>
> ...total versions: 27565987 !!!, max versions: 6180!!!
>
> What does the initial database header stats look like (Oldest
> Transaction, Oldest Active Transaction...)?
>
>
> Sean
>