Edit Report a Bug

    sqlsrv_configure

    (No version information available, might only be in Git)

    sqlsrv_configure — Changes the driver error handling and logging configurations

    Beschreibung

    sqlsrv_configure(string $setting, mixed $value): bool

    Changes the driver error handling and logging configurations.

    Parameter-Liste

    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)

    Rückgabewerte

    Gibt bei Erfolg true zurück. Bei einem Fehler wird false zurückgegeben.

    add a note add a note

    User Contributed Notes 1 note

    up
    -8
    smhahmadi
    11 years ago
    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).
    add a note add a note
    To Top