Subject | One table taking a long time to insert/update |
---|---|
Author | robertgilland |
Post date | 2008-06-25T06:53:15Z |
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.
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.