Hi,

I think your problem is not firebird related, but .NET provider related.
It closes the connection, because it uses short life cycle objects. It
won't keep your connection opened if you don't really need them.
You should make a connection on the first attempt, then somehow keep it
opened.

SanTa

2010.06.18. 10:46 keltezéssel, Puigsegur, Jordi írta:

> 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.
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]