jeff_j_dunlap wrote:

> I am using Firebird 2.0.3 running on a Windows 2003 Web Ed. It has
> worked very reliably but I've had to experiment with workarounds in
> order to keep my database cached after disconnecting from it.
>
> The performance hit (due to lost db cache) is easily overcome simply
> by LEAVING THE DATABASE OPEN but I've been told that keeping it open
> indefinately is not a good idea for FB. I've noticed that even if a
> secondary application has the database open, the cache is not lost.
>
>

Keeping a conection does not hurt FB in anyway... the problem is keeping
a transaction open.

Just keep an attachment without a transaction started and everything is ok.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br