c-treeACE V11.0 Update Guide

c-treeACE SQL ODBC Ability to Set "Default Fetch Size" in DSN or Connection String

It is possible to set a "Default Fetch Size" in bytes in the DSN. This value is the size used internally by the driver to fetch multiple rows from the server. This setting reduces network requests resulting in performance gains. If not set, the internal buffer size is 5000 bytes.

In your connection string, set the attribute "FETCH_SIZE=[number of bytes]"

In your ODBC.INI file, set the attribute "Default Fetch Size=[number of bytes]"

Connection string settings take precedence over DSN/ODBC.INI settings.