Subject | Re: [firebird-support] Slow update on subsequent call within a |
---|---|
Author | Jaison Gmail |
Post date | 2009-08-19T07:37:50Z |
Dmitry Yemanov wrote:
TRG_TRG (161)
Primary pointer page: 298, Index root page: 299
Average record length: 37.91, total records: 28386
Average version length: 9.00, total versions: 28132, max versions: 1
Data pages: 587, data page slots: 587, average fill: 96%
Thanks
Jaison
[Non-text portions of this message have been removed]
> Jaison Gmail wrote:gstat gives this output :)
>
>>
>>
>>> Out of curiosity, how many record versions does this table have?
>>>
>>>
>
>
TRG_TRG (161)
Primary pointer page: 298, Index root page: 299
Average record length: 37.91, total records: 28386
Average version length: 9.00, total versions: 28132, max versions: 1
Data pages: 587, data page slots: 587, average fill: 96%
>> If you want, I shall email the test db (privately) to you, for furtherI already sent it to you. Please tell me if it did not reach you.
>> investigation. It is less than 2 MB when zipped.
>>
>
> Would be appreciated, as I'm getting curious myself ;-)
> Just please change the archive extension, as the SourceForge doesn't
> accept zip attachments.
>
>
> Dmitry
>
>
Thanks
Jaison
[Non-text portions of this message have been removed]