Re: [Firebird-devel] MaxFileSystemCache (was Re: FB 2.1 64bit and

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

On Friday 27 July 2007 20:51, Dmitry Yemanov wrote:
> Adriano dos Santos Fernandes wrote:
> > Since we maintain the cache per-database, when all attachments are
> > disconnected, we loose all the cache, causing very huge performance
> > problems.
>
> Do you mean problems in subsequent [newly created] attachments? Well,
> this is a kind of expected. The apps often connecting/disconnecting
> should not use this feature, IMO.

Problems happening after non-working night may be solved adding one more 
attachment to database, doing nothing by itself. But what about database 
shutdown - if one uses single attachment to shutdown database, do some 
actions with it and bring it back online, cache will be preserved. But if one 
needs to change attachments in single-user shutdown mode cache will be 
dropped. Suppose well designed system do not need this mode too often.