Subject Re: PConnect -v- Connect
Author Fabrice Aeschbacher
Ian,

We use Winxxx, Apache 1.3.19, PHP 4.0.4, ADODB, Firebird 0.9.4.41.
We have encountered a very big problem with pconnect(), which
prevented us from using it: pconnect actually do not close connection
to db, but also do not always re-use the already opened one(s). It
means that pconnect() frequently opens new connections. You can very
quickly have many tens of opened connections.
Moreover, you cannot close with ibase_close() (or adodb.close) a
connection opened with pconnect().
There must be a bug; I tried to isolate it in the source code, but it
is not obvious to debug.
So for now, we must use connect(), even if slower.

Fabrice

--- In ib-support@y..., ian <ian.mellor@l...> wrote:
> We are running:
> SuSE6.4, Apache 1.3.12-15, PHP 4.0.4p11,
> PHPLIB 7.2, ADODB 1.12, IB LI-06.0.1.6 (we think)
>
> We have been using PConnect when creating connections through PHP.
> Previously with both MySQL and Postgres this was acting as we
expected.
> With interbase, however, after a while pages timeout on the first
> attempt, and need a manual "reload" to fetch. I changed my PConnect
to a
> Connect and the problems vanished only to reappear when i put it
back!
>
> In "A Sample PHP3/Interbase pplication",
> http://www.synetics.co.za/php3/tutorial/sample-app.html, section
> "Connecting to Interbase" the author says "...I have encountered
> problems with the Interbase connection timing out when connection
via a
> network..." - is this a known feature and if so is there a work
around
> as we want to be well behaved and reuse our connections?
>
> yours, as ever,
> Ian