Subject | Re: PConnect -v- Connect |
---|---|
Author | Fabrice Aeschbacher |
Post date | 2001-06-18T07:38:30Z |
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
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