InsensitiveResultSetBufferSize
- Last Updated: February 28, 2022
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Informix 6.0
- Documentation
Purpose
Determines the amount of memory used by the driver to cache insensitive result set data.
Valid Values
-1 | 0 | x
where:
- x
- is a positive integer that represents the size of the memory buffer.
Behavior
If
set to -1, the driver caches insensitive result
set data in memory. If the size of the result set exceeds available
memory, an OutOfMemoryException is generated. With no need to write
result set data to disk, the driver processes the data efficiently.
If
set to 0, the driver caches insensitive result
set data in memory, up to a maximum of 2 GB. If the size
of the result set data exceeds available memory, the driver pages
the result set data to disk. Because result set data may be written
to disk, the driver may have to reformat the data to write it correctly
to disk.
If set to x, the driver caches insensitive result set data in memory and uses this value to set the size (in KB) of the memory buffer for caching insensitive result set data. If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in efficient memory use.
Data Source Methods
public Integer
getInsensitiveResultSetBufferSize()
public void
setInsensitiveResultSetBufferSize(Integer)
Default
2048
Data Type
Integer