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

[Claudio V. C. <cv...@us...>]

> -----Original Message-----
> From: Ann W. Harrison [mailto:aha...@ib...] 
> Sent: Miércoles, 06 de Enero de 2010 14:29
> To: For discussion among Firebird Developers
> 
> The mental model for most databases is that they hold valuable data
> that the users want to save - not that they model a volatile state
> that's going to be destroyed when the test is over.  The last-PIP
> optimization works pretty well in the first model and badly in the
> second.  A way of dealing with the second case would be to reset the
> saved last-PIP when an earlier PIP crosses some threshold of free
> pages.

I don't know if the test is artificial or represents some real usage
patterns, but we have global temporary tables now.

C.