Subject Re: [firebird-php] Re: Web Apps - cache lost when db disconnects
Author Milan Babuskov
jeff_j_dunlap wrote:
> Milan,
> Thanks for responding. I was reading various threads on the FB
> newsgroup and some people say that OS cache is slower than FB cache.

I don't know about Windows, but on Linux OS cache is about 10% faster.
Fikret (Hasovic) and I did some benchmark tests during the Conference
and came to this conclusion.

> My workaround has been similar to what you suggested since the
> application opens up a dummy connection that stays alive for 4 hours
> (maybe this connection can stay alive indefinitely according to
> Alexandre Benson Smith). This connection does nothing but keep FB
> cached and certainly speeds up my database response time.

The connection can stay alive as long as you want the cache, no problem
with that (just read Helen's tip about transactions). In fact, on one
server in production I have a client app. which has been connected for
more than 5 months, and it is doing nothing most of the time.

Milan Babuskov