Reader Caching
Reader caching is internally implemented by setting the statement attribute SQL_ATTR_ROW_ARRAY_SIZE. Reader caching is fully supported by the DB Access Module for ODBC.
Increasing the cache parameter when producing an
RWDBReader increases the number of rows fetched at a time, which can improve performance.
NOTE: Increasing the cache size may improve performance, depending on your application and driver.
