--- In firebird-php@yahoogroups.com, masotti <masotti@...> wrote:

>
> Hi Jeff,
>
> I don't understand where your problem is PHP related, (i.e. there is

C++

> code sample).
> Perhaps your questions are better related to Firebird support or
> Firebird general.
> Search in http://www.firebirdsql.org/index.php?op=lists for lists if

you

> don't find them.
>
> Ciao.
> Mimmo.

Sorry about that, I had posted in the wrong yahoo newsgroup.

Now that I'm here, I'm curious to know how what PHP programmers do to
keep a database open for continuous use?

For example, if I create a cgi executable in C++, the executable
executes when an http request comes in. It processes the request then
terminates when complete. In this model, the executable cannot keep a
connection open, therefore must open/close a connection for each
request. Please note that I have no experience thus cannot comment
how it would work using fastcgi.

To overcome this limitation, I wrote my application as an isapi dll
that opens a connection at startup and remains active waiting for
requests.

In my original post, I did some testing and saw that keeping a
connection open is much more efficient than opening and closing a
connection for each request. I'm very glad that I found this out
because I was unhappy with the delay caused by each connect for each
request.

Anyway, do PHP programmers also keep an instance of FB connected to
quickly handle requests? If so, I imagine that you do not use the cgi
model that I mentioned above right? You probably use something
similar to the mentioned isapi model?