This section describes inserter and reader caching.
Inserter caching is implemented in the DB Access Module for PostgreSQL as described for the DB Interface Module. The DB Access Module for PostgreSQL does not support input binding of data. All values are sent as literals upon execution of the SQL statement.
Reader caching is fully supported by the DB Access Module for PostgreSQL. Increasing the cache parameter when producing an
RWDBReader increases the number of rows fetched at a time, which can improve performance.