Subject One table taking a long time to insert/update
Author robertgilland
We are using firebird 2.03.

We are finding the below table to take a long time to update/insert.

ie. 25 minutes for 8000 records inserting.

Can anyone explain what the below statistics actually mean?

BIGTABLE (130)
Primary pointer page: 311, Index root page: 312
Data pages: 314051, data page slots: 314051, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7
80 - 99% = 314044

Kind Regards,

Robert.