Inserter caching is implemented by setting the statement attribute SQL_ATTR_PARAMSET_SIZE on the SQLHSTMT. Inserter caching is fully supported by the DB Access Module for DB2 CLI.
Reader caching is implemented by setting the statement attribute SQL_ATTR_ROW_ARRAY_SIZE on the SQLHSTMT. Reader caching is fully supported by the DB Access Module for DB2 CLI.
Increasing the cache parameter when producing an RWDBReader increases the number of rows fetched at a time, which can improve performance. By default, the cache size is set at 10.
NOTE -- Increasing the cache size can improve performance.
© Copyright Rogue Wave Software, Inc. All Rights Reserved.
Rogue Wave and SourcePro are registered trademarks of Rogue Wave Software, Inc. in the United States and other countries. All other trademarks are the property of their respective owners.
Contact Rogue Wave about documentation or support issues.