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

[Alexander P. <pes...@ma...>]

On Friday 08 January 2010 16:15:20 Vlad Khorsun wrote:
> > 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.