Re: pg_pconnect+PostgreSQL cursors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



on 12/26/02 9:59 AM, serg@xxxxxxxxxxxxxx purportedly said:

> I've got closing of cursor and transaction! why??? I use permanent connection,
> why I've got closing of cursor and transaction!???

The "p" in "pconnect" means *persistent*, not permanent. The connection will
persist after the script has completed, however, the connection is handled
by the web server process and its true lifetime is only the lifetime of the
process. For Apache, this will vary by configuration, and is difficult to
predict when hosting multiple sites.

Tip: persistent connections are only useful when you want (and have the
resources to support) to minimize connection overhead. Any other use and you
are likely to be severely disappointed.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux