sqlsrv_commit
Performance tip:
Beware of the performance penalty involved with unchecked use of logging options. In my case, although I was using the buffered cursor, sqlsrv_fetch_array was running too slowly. The solution was to remove my lavish use of those configuration options (using both SQLSRV_LOG_SYSTEM_ALL and SQLSRV_LOG_SEVERITY_ALL).
sqlsrv_configure
(No version information available, might only be in SVN)
sqlsrv_configure — Changes the driver error handling and logging configurations
Description
Changes the driver error handling and logging configurations.
Parameters
-
setting -
The name of the setting to set. The possible values are "WarningsReturnAsErrors", "LogSubsystems", and "LogSeverity".
-
value -
The value of the specified setting. The following table shows possible values:
Error and Logging Setting Options Setting Options WarningsReturnAsErrors 1 ( TRUE) or 0 (FALSE)LogSubsystems SQLSRV_LOG_SYSTEM_ALL (-1) SQLSRV_LOG_SYSTEM_CONN (2) SQLSRV_LOG_SYSTEM_INIT (1) SQLSRV_LOG_SYSTEM_OFF (0) SQLSRV_LOG_SYSTEM_STMT (4) SQLSRV_LOG_SYSTEM_UTIL (8) LogSeverity SQLSRV_LOG_SEVERITY_ALL (-1) SQLSRV_LOG_SEVERITY_ERROR (1) SQLSRV_LOG_SEVERITY_NOTICE (4) SQLSRV_LOG_SEVERITY_WARNING (2)
Return Values
Returns TRUE on success or FALSE on failure.
add a note
User Contributed Notes
sqlsrv_configure - [1 notes]
smhahmadi ¶
3 months ago