Increasing the Performance of the Denodo ODBC Driver¶
This section describes an option that has been deprecated and is going to be removed in the next major version. The speed improvement provided by this option is insignificant and after enabling it, ODBC clients only can use the Denodo ODBC driver.
To increase the speed at which the Denodo ODBC driver returns numeric values, do the following:
- Log in to the Virtual DataPort Administration Tool as an administrator user.
- From the VQL Shell, execute this:
SET 'com.denodo.vdb.vdbinterface.server.odbc.forceBinaryTypes' = 'true';
Only set this property if all the clients that connect to Denodo through the ODBC interface use the Denodo ODBC driver. The connections opened from clients that use a different ODBC driver will crash.