InsensitiveResultSetBufferSize
- Last Updated: January 17, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Apache Spark SQL 6.0
- Documentation
Purpose
Determines the amount of memory that is used by the driver to cache insensitive result set data.
Valid Values
-1 | 0 |
x
where:
- x
- is a positive integer that represents the amount of memory.
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 MB. If the size of the result set data exceeds available memory, then
the driver pages the result set data to disk, which can have a negative
performance effect. 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, then the driver pages the result set data
to disk, which can have a negative performance effect. 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 Method
setInsensitiveResultSetBufferSize
Default
2048
Data Type
int