The number of 64 KB blocks the driver uses to cache database records. The larger the number of blocks, the better the performance.
Valid Values
0 | x
where:
x
is a positive integer that specifies the number of 64 KB blocks for caching.
Behavior
If set to 0, no records are cached.
If set to x, the specified number of 64 KB blocks are set aside for caching. The maximum number of blocks you can set depends on the system memory available. If the cache size is greater than 0, when browsing backwards, you are not able to see updates made by other users until you run the Select statement again.
