| Subject | Re: [firebird-support] One table taking a long time to insert/update |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-06-25T07:30:30Z |
At 04:53 PM 25/06/2008, you wrote:
What it does tell us is that the database has been set up to use all space. If not, you would see the bulk of your data residing in the 60 - 79% (or lesser) zones. Normally you would only do this with a read-only database, with a view to shipping a slightly smaller file on some transportable medium.... it's not an optimal way to configure a database that's going to be maintained.
./heLen
>We are using firebird 2.03.It's saying that nearly all of your data pages are using more than 80% of the space on them. Of course, it doesn't say what's on those pages - there could be a lot of garbage, for example, which would tend to kill performance.
>
>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
What it does tell us is that the database has been set up to use all space. If not, you would see the bulk of your data residing in the 60 - 79% (or lesser) zones. Normally you would only do this with a read-only database, with a view to shipping a slightly smaller file on some transportable medium.... it's not an optimal way to configure a database that's going to be maintained.
./heLen