Programming the Perl DBI

Name

RowCacheSize (integer) (NEW )

Synopsis

A hint to the driver indicating the size of the local row cache that the application would like the driver to use for future SELECT statements. If a row cache is not implemented, then setting RowCacheSize is ignored and getting the value returns undef.

Some RowCacheSize values have special meaning, as follows:

0

Automatically determine a reasonable cache size for each SELECT.

1

Disable the local row cache.

>1

Cache this many rows.

<0

Cache as many rows that will fit into this much memory for each SELECT.

Note that large cache sizes may require a very large amount of memory (cached rows × maximum size of row). Also, a large cache will cause a longer delay not only for the first fetch, but also whenever the cache needs refilling.

See also the RowsInCache statement handle attribute.