ID: 37594
Updated by: [EMAIL PROTECTED]
Reported By: mzamora at meritlending dot com
-Status: Open
+Status: Feedback
Bug Type: MSSQL related
Operating System: windows 2000 sp4
PHP Version: 5.1.4
Assigned To: fmk
New Comment:
Both the DBLIB and MSSQL versions of this extension uses the exact same
C code. The difference between the two versions is the library used. The
Library supplied by Microsoft and used in php_mssql.dll is not thread
safe. Microsoft has not updated this library since SQL Server 6.5.
The extension named php_dblib.dll uses FreeTDS and there are ways to
improve performance as this is an open source project.
In both cases it's the same server the performs the queries and it's
the same C code that handles the output from the library, so the only
differences I see is the transport protocols. If you have some examples
of quieries that acts slower I'll take a look at those and see if tehre
is anything that can be done.
Previous Comments:
------------------------------------------------------------------------
[2006-06-05 22:34:40] mzamora at meritlending dot com
We have been running with php_dblib.dll for a little over a week now
and have not noticed any instability issues.
Is there any additional information that we can provide to assist in
isolating the issue within mssql.dll? We are very interested in
getting a stable version of mssql.dll as running with php_dblib.dll has
caused a sizable increase in our query times.
------------------------------------------------------------------------
[2006-05-30 15:44:19] mzamora at meritlending dot com
We have the server running with the php_dblib.dll, but because of the
long holiday weekend the server has not been under the load level that
causes the failure.
------------------------------------------------------------------------
[2006-05-26 06:24:02] [EMAIL PROTECTED]
Let's leave at feedback until then then.
------------------------------------------------------------------------
[2006-05-26 00:13:40] mzamora at meritlending dot com
we are using php5apache2.dll. It will be some time tomorrow before I
get a chance to do any testing with php_dblib.dll.
------------------------------------------------------------------------
[2006-05-25 23:54:13] [EMAIL PROTECTED]
Are you using CGI or php5apache2.dll?
The library used by the mssql extension is not thread safe. You might
want to try php_dblib.dll. It's the same mssql_*() functions but it's
compiled against FreeTDS.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/37594
--
Edit this bug report at http://bugs.php.net/?id=37594&edit=1
