Bug #14948 Updated: mssql_pconnect opens connection everytime is called
| From: | spilka at adash dot cz | Date: | Thu, 10 Jan 2002 07:22:56 +0000 |
| Subject: | Bug #14948 Updated: mssql_pconnect opens connection everytime is called | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-76452@lists.php.net to get a copy of this message | ||
ID: 14948
User updated by: spilka@adash.cz
Reported By: spilka@adash.cz
Status: Open
Bug Type: MSSQL related
Operating System: NT 4.0 SP5
PHP Version: 4.1.1
New Comment:
Apache 1.3.22
Win NT SP5
PHP 4.1.1, run as DLL Apache module
MSDE SQL server
mod_mssql module loaded
The web server with PHP module and SQL server are running on the same
machine.
Problem:
When opening connection to MSSQL database with mssql_pconnect, the
connections are not persistently used.
Instead, new connection is opened everytime. MSSQL sp_who2
clearlz determines this (everytime REFRESH inbrowser is called new
connection pops up).
Ondra.
Previous Comments:
------------------------------------------------------------------------
[2002-01-09 09:44:21] spilka@adash.cz
Apache 1.3.22
Win NT SP5
PHP 4.1.1, run as DLL Apache module
MSDE SQL server
mod_mssql module loaded
Problem:
When opening connection to MSSQL database with mssql_pconnect, the
connections are not persistently used.
Instead, new connection is opened everytime. See MSSQL sp_who2
results:
SPID Status DBName Command CPUTime DiskIO LastBatch
ProgramName SPID
----- ---------- ------ ---------------- ------- ------ --------------
-------------- -----
1 sleeping master SIGNAL HANDLER 0 0 01/09 15:07:02
1
2 BACKGROUND UKOLY LOCK MONITOR 0 0 01/09 15:07:02
2
3 BACKGROUND UKOLY LAZY WRITER 0 0 01/09 15:07:02
3
4 sleeping UKOLY LOG WRITER 0 0 01/09 15:07:02
4
5 sleeping UKOLY CHECKPOINT SLEEP 0 0 01/09 15:07:02
5
6 BACKGROUND UKOLY AWAITING COMMAND 0 5 01/09 15:07:02
6
7 RUNNABLE UKOLY SELECT INTO 0 169 01/09 15:41:39
MS SQL Query 7
8 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:34
PHP 4.0 8
9 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:31
PHP 4.0 9
10 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:37
PHP 4.0 10
11 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:39
PHP 4.0 11
12 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:40
PHP 4.0 12
13 sleeping UKOLY AWAITING COMMAND 0 0 01/09 15:41:41
PHP 4.0 13
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=14948&edit=1