note 23396 added to function.mssql-pconnect
| From: | m1tk4 at hotmail dot com | Date: | Wed, 17 Jul 2002 13:08:10 +0000 |
| Subject: | note 23396 added to function.mssql-pconnect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-33207@lists.php.net to get a copy of this message | ||
Be careful with pconnect!
Platform: RH Linux 7.3, PHP 4.2.1. FreeTDS.
pconnect does give you better time than connect (about 0.25-0.4 seconds gain) BUT:
- occasionally, I've experienced "quirks" when fetch() would randomly return empty
recordsets from stored procedurest that can_not return empty recordsets by definition.
- if you restart MSSQL server while some of the connections did not time out, next pconnect() will
not establish a new connection! It will return an old one, so next time you do execute() or query()
your script will just _hang_ until timeouted by Apache.
All of the above I believe are FreeTDS problems, not PHP. I wonder if somebody with PHP+Sybase lib
got pconnect to work.
--
http://www.php.net/manual/en/function.mssql-pconnect.php
http://master.php.net/manage/user-notes.php?action=edit+23396
http://master.php.net/manage/user-notes.php?action=delete+23396
http://master.php.net/manage/user-notes.php?action=reject+23396