SQLPERFORMANCESQL

Improve SQL statement caching for SQL Server

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows

 

 

The SQLPERFORMANCESQL environment variable causes SQL Connection to use SQLDescribeParam internally to improve performance for SQL statements with I/O parameters when accessing SQL Server.

Value

Any value.

Discussion

Set this environment variable to any value to improve performance and avoid excessive cache memory thrashing for SQL statements with I/O parameters when accessing SQL Server (VTX12_SQLNATIVE). When this is set, SQL Connection calls the ODBC API function SQLDescribeParam internally for all SQL Server cursors. (For an option that invokes this functionality only for cursors opened on a specified database channel, see SSQL_PERFORMANCE_SQL.)

Important

Because this uses SQLDescribeParam, the case of column names in statements must match the case of the column names in the database.

Setting location

The environment or synergy.ini. For client/server configurations, set SQLPERFORMANCESQL on the client.

Used by

SQL Connection

Examples

SQLPERFORMANCESQL=1