Suppressing Row Format Metadata to Improve Query Performance

Suppress row format metadata (TDS_ROWFMT or TDS_ROWFMT2) when queries that are reexecuted in a session to improve the performance of repeatedly executed queries with the ODBC driver and ADO.NET Data Provider.

Adaptive Server 15.7 ESD#1 and later supports row format metadata suppression.

Use the SuppressRowFormat connection string property.

The valid SuppressRowFormat connection string property values are:

0 – row format metadata is not suppressed.
1 – the default value; Adaptive Server does not send row format metadata where possible.

Note: You can suppress row format metadata only if the connected Adaptive Server supports this feature. If the SuppressRowFormat parameter is set to 1 but the connected Adaptive Server does not support the suppression of row format metadata, Adaptive Server ignores the parameter setting.

Example

This ODBC connection string suppresses row format metadata:

DSN=sampledsn;UID=user;PWD=password;;DynamicPrepare=1;
SuppressRowFormat=1;