Suppressing row format metadata to improve query performance

You can improve the performance of repeatedly executed queries with the ODBC driver and ADO.NET Data Provider by instructing Adaptive Server to suppress row format metadata (TDS_ROWFMT or TDS_ROWFMT2) for queries that are reexecuted in a session. Adaptive Server 15.7 ESD#1 and later supports row format metadata suppression.

To suppress row format metadata, 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.

This ODBC connection string suppresses row format metadata:

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