Increasing the Performance of 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.