Hi,
One thing the firebird book does not go into much depth with is
gstat -r , the record version information.

Heres a table, total versions make 1% of the total,

What are impacts of letting the below happen.

PURCHTRAN (160)
Primary pointer page: 1415, Index root page: 1416
Average record length: 301.28, total records: 873801
Average version length: 289.08, total versions: 9034, max versions: 29
Data pages: 88096, data page slots: 93385, average fill: 87%
Fill distribution:
0 - 19% = 3597
20 - 39% = 1641
40 - 59% = 1275
60 - 79% = 645
80 - 99% = 80938

I presume that the database engine takes longer to find the correct record.
Fine, but any idea of the cost of letting this happen and perhaps whats
acceptable? Or where to look to appreciate the cost.


Cheers

Alex.