New jConnect Connection Properties for Performance Improvement

Starting with ESD #4, jConnect for JDBC has new set of connection properties for performance improvement.

Property	Description	Default value
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: false – TDS_PARAMFMT is not suppressed in select, insert, and update operations. true – the default value; TDS_PARAMFMT is suppressed where possible.	true
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: false – TDS_ROWFMT or TDS_ROWFMT2 data is sent, even if the row format has not changed. true – the default; forces the server to send TDS_ROWFMT or TDS_ROWFMT2 only when the row format has changed.	true

Property

Description

Default value

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.

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:

false – TDS_PARAMFMT is not suppressed in select, insert, and update operations.
true – the default value; TDS_PARAMFMT is suppressed where possible.

true

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:

false – TDS_ROWFMT or TDS_ROWFMT2 data is sent, even if the row format has not changed.
true – the default; forces the server to send TDS_ROWFMT or TDS_ROWFMT2 only when the row format has changed.

true