Specifies the Columnsize of a cursor variable. For example, when a default varchar column is created in FileMaker, the database defines it at 1000000 chars. When the application requests a static cursor on a Unicode data source, the driver allocates 3000000 (UTF-8) bytes for this type of column. When multiple varchar columns exist, the application slows down because of disk access in the static cursor. In practice, no applications use 1000000 chars; thus, limiting the column size makes the rowbuffer size smaller and reduces disk access. The ODBC application can specify a parameter in the connection string, for example, LimitCursorColumnsize=1000.
Note: On the OpenAccess SDK Server, this workaround can be set using the attribute DataSourceLimitCursorColumnsize. Refer to the OpenAccess SDK Administrator’s Guide for information about this service attribute.
