Configuration of Server SQLDA Structure Size for Reduced Memory Usage with c-treeSQL

The c-treeSQL SQLDA is a storage area for descriptive information pertaining to dynamic SQL statements. An SQLDA can be used while passing parameter values and while retrieving results.

The size of this structure has been reduced in an effort to reduce memory usage. The default SQLDA structure has been reduced. This parameter controls the size of the structure in the server and the size of the fetch ahead buffer.

This size can be configured with a c-treeSQL Server configuration keyword:

SETENV DH_SVR_DA_BUFFER

In addition, internal size calculations of structure members have been modified for more efficient memory use.