| Subject | Re: ODP: [firebird-support] Re: Strange behavior on very large table |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2019-03-02T10:03:44Z |
02.03.2019 10:50, Karol Bieniaszewski liviuslivius@... [firebird-support] wrote:
record length is not big enough to fill data pages completely so I would guess that his
application may do something strange: insert "empty" record and then update it with data.
That would be bad.
--
WBR, SD.
> You have quite big fill 94%, that there is a chence that new page must be allocated – butIt may be a sign of record fragmentation which is bad from performance POV. Average
> here still you have free slots.
record length is not big enough to fill data pages completely so I would guess that his
application may do something strange: insert "empty" record and then update it with data.
That would be bad.
--
WBR, SD.