New jConnect connection properties for performance improvement

OPTIMIZE_STRING_ CONVERSIONS

Specifies whether or not to enable string conversion optimization.

This optimization behavior can improve jConnect performance when a client uses character datatypes in SQL prepared statement.

Values:

• 0 – the default value; string conversion optimization is not enabled.

• 1 – enable string conversion optimization when jConnect uses utf8 or server default character set.

• 2 – enable string conversion optimization for all cases.

0

SUPPRESS_PARAM_ FORMAT

When executing dynamic SQL prepared statements, jConnect client can use the SUPPRESS_PARAM_FORMAT connection string property to suppress parameter data (TDS_PARAMS). The client sends less parameter metadata where possible for better performance.

Values:

• 0 – TDS_PARAMFMT is not suppressed in select, insert, and update operations.

• 1 – the default value; TDS_PARAMFMT is suppressed where possible.

1

SUPPRESS_ROW_ FORMAT

In jConnect, client can use the SUPPRESS_ROW_FORMAT connection string property to force Adaptive Server to send TDS_ROWFMT or TDS_ROWFMT2 data only when the row format changes for a dynamic SQL prepared statement. Adaptive Server can send less data to the client if possible, resulting in better performance.

Values:

• 0 – TDS_ROWFMT or TDS_ROWFMT2 data is sent, even if the row format has not changed.

• 1 – the default; forces the server to send TDS_ROWFMT or TDS_ROWFMT2 only when the row format has changed.

1