Inserter caching is implemented by setting the statement attribute SQL_ATTR_PARAMSET_SIZE on the SQLHSTMT being used. Inserter caching is fully supported by the DB Access Module for Microsoft SQL Server.
Reader caching is implemented by setting the statement attribute SQL_ATTR_ROW_ARRAY_SIZE on the -SQLHSTMT being used. Reader caching is fully supported by the DB Access Module for Microsoft SQL Server.
Increasing the cache parameter when producing an RWDBReader increases the number of rows fetched at a time, which can improve performance. The default cache size is set at 10.
Increasing the cache size may improve performance, depending on your application.
Copyright © Rogue Wave Software, Inc. All Rights Reserved.
The Rogue Wave name and logo, and SourcePro, are registered trademarks of Rogue Wave Software. All other trademarks are the property of their respective owners.
Provide feedback to Rogue Wave about its documentation.