Subject Re: Web Apps - cache lost when db disconnects
Author jeff_j_dunlap
--- In, Milan Babuskov <milanb@...> wrote:

> Of course, that's the way it works.
> If you really want to have it cached, use Linux (so filesystem will
> cache it) or set up some dummy client to get the database attached.


Thanks for responding. I was reading various threads on the FB
newsgroup and some people say that OS cache is slower than FB cache.

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.