Subject | Re: Web Apps - cache lost when db disconnects |
---|---|
Author | jeff_j_dunlap |
Post date | 2008-10-16T14:03:12Z |
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:
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
<iblist@...> wrote:
> Keeping a conection does not hurt FB in anyway... the problem isCan I safely keep a dummy connection open for months without problems?
> keeping a transaction open.
>
> Just keep an attachment without a transaction started and
> everything is ok.
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