Alan McDonald wrote:

> I have discovered that the first connection to the database is the
> problem. When I open isql and connect, everything works great from PHP
> while isql is connected. As soon as I disconnect with isql, it works for
> few pages and then I get the problems again.
>
> So I made the conclusion that there is some problem when FB is attaching
> the database file. But I don't know how to solve it. Right now, the
> server has always one isql connected, and everything works, but I
> consider that "a dirty hack", not a solution.
>
> Can you please try it, and tell us if it is the same problem.
>
> [Alan McDonald] Not sure about this - otherwise it would be slow on every
> page. Since each page makes a separate connection and work in the page is
> coarried out on that connection, then the connection is dropped. I do not
> experience speed issues on each and evgery page, only when hiting a page
> after letting site lie idle for a few minutes.

Well, it is very similar. Can you please just try to connect with isql,
and stay connected, and then see if you still have problems. Please.

--
Milan Babuskov
http://fbexport.sourceforge.net