Subject timeout for firebird to close a database
Author Puigsegur, Jordi
Hi all,

We use Firebird 2.1.2 64 bits on Windows 2003 server and Firebird .NET data provider. We've noticed that firebird closes the database when there are no more open connections, and then the respective cache (page buffer) is deleted. This seems to happen some seconds after the last connection is closed. The effect on our application is that under light load it is much slower because every now and then the database file is closed and the database cache gets deleted.

Is there any way to control the timeout for the database to be closed after the last connection is closed? I didn't see anythin, neither in firebird.conf nor in the documentation/web site. I understand that keeping an open connection to the database will also do the trick. First I would like to know if there is another way of solving this issue.

Finally, some weeks ago I asked the following question on the list but I didn't get an answer:

> Hi all,
>
> We are waiting for the release of the new Firebird 2.5, mainly because it
> will allow us to keep a several Gb database (~10Gb) in memory for faster
> queries (We use 64 bit Windows 2003 server).
>
> Anyone has an idea of when it is going to be released? I've looked at the
> roadmap in the web and seems outdated.
>
> Is 2.5 RC2 stable enough to risk start using it before its release?

Any idea?

Jordi.