Re: [Firebird-devel] Firebird 2.5: Performance degradation andincreasing file size

[Gary F. <Gar...@sa...>]

Sorry, I was pulled away on another issue.  I will capture this information and post.

Gary

-----Original Message-----
From: Vlad Khorsun [mailto:hv...@us...] 
Sent: Friday, January 08, 2010 7:33 AM
To: fb-devel
Subject: Re: [Firebird-devel] Firebird 2.5: Performance degradation andincreasing file size

>> > Also please pay attention - the fact that server does not reuse pages
>> > after 'DROP TABLE' does not explain performance degradation. If for any
>> > run each table containt X pages, why should we have visible performance
>> > difference when this pages are located in the beginning of the file or in
>> > the end of it. Specially well seen in series 11-20 from original Gary's
>> > letter.
>>
>>     Seems like DROP and subsequent CREATE TABLE was failed. And
>> garbage collection is blocked during test run.
> 
> But why did database become smaller after backup+restore in that case? 
> Remember, no DELETE FROM, only DROP.

    Good question ;)

    We can guess a long time without more info. I would like to see gstat -r
output during test run (as Ann already told). Also it is interesting to see
results of gfix -v -full after the runs.

Regards,
Vlad

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel