Subject Re: Web Apps - cache lost when db disconnects
Author jeff_j_dunlap
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

> 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.

Can I safely keep a dummy connection open for months without problems?

My application is a windows dll that starts up once (it loads a dummy
db connection and closes/reopens it every 4 hours) and attends to
incoming web requests. This application is never shut down (only when
I reboot the server). If the application crashes, it will be
restarted automatically by IIS.

My main reason for this post is because I'm going to write a second
application and I wanted to find an improved way of buffering my database.

If I understand correctly, the reopening the dummy connection is not
necessary. I can simply leave the dummy connection open indefinitely.

Is this correct?

Thanks Again,

Jeff