Subject Re: One table taking a long time to insert/update
Author robert.gilland
> There's a -r switch to gstat that gives you more information on
> records in the table, including old record versions and version
> chains. Run that, send your results, and I'll explicate the output.
>
>

Database "E:\Data\DBASE.GDB"
Database header page information:
Flags 0
Checksum 12345
Generation 4526942
Page size 16384
ODS version 11.0
Oldest transaction 4391647
Oldest active 4391648
Oldest snapshot 4390774
Next transaction 4526929
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 65535
Next header page 0
Database dialect 3
Creation date Jun 15, 2008 3:19:06
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File E:\Data\DBASE.GDB is the only file

Analyzing database pages ...
TABLE1 (130)
Primary pointer page: 311, Index root page: 312
Average record length: 126.03, total records: 31114063
Average version length: 9.00, total versions: 202075, max
versions: 3
Data pages: 317927, data page slots: 317927, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 8
80 - 99% = 317919

TABLE2 (140)
Primary pointer page: 331, Index root page: 332
Average record length: 120.15, total records: 18839918
Average version length: 22.19, total versions: 75578, max
versions: 5
Data pages: 185618, data page slots: 185618, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 139
80 - 99% = 185478


Both the above tables are of concern.

Kind Regards,

Robert