This section describes inserter and reader caching.
Inserter caching is implemented by setting the statement attribute SQL_ATTR_PARAMSET_SIZE. Inserter caching is fully supported by the DB Access Module for ODBC; however, some drivers do not support the ODBC functionality upon which inserter caching is implemented.
If the driver does not support inserter caching, an error from the driver occurs, and the insertion is not performed. The usual error message is Optional feature not implemented.
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.
Increasing the cache size may improve performance, depending on your application and driver.
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.