Remote query performance degrades with DATETIME column – SAP Sybase IQ16.0
and the default Open Client/Server included with
SAP Sybase IQ16.0
support the TDS BIGDATETIME data type
for remote queries.
When an SAP Sybase IQ server
executes a remote query using Open Client and fetches a
DATETIME column on an IQ/SA remote
server, the return data type is
BIGDATETIME, instead of
DATETIME. This may degrade
performance.
This performance degradation may not occur, when the
remote server is an ASE server.
To prevent the return of BIGDATETIME
values, apply this workaround.
Workaround – Add these lines to the Open Client and Open Server
configuration file
$SYBASE/$SYBASE_OCS/config/ocs.cfg
to prevent the return of BIGDATETIME values:
[SAP Sybase IQ]
CS_CAP_RESPONSE = CS_DATA_NOBIGDATETIME