robertgilland wrote:

>
> We are finding the below table to take a long time to update/insert.
>
> ie. 25 minutes for 8000 records inserting.

That is slow. How many indexes do you have on the table?

>
> 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
>

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.


Cheers,


Ann