Determines whether the driver caches long data (images, pictures, long text, binary data, or XML data) in result sets. To improve performance, you can disable long data caching if your application retrieves columns in the order in which they are defined in the result set.
Valid values
-1 | 0 | x
where:
x
is a positive integer in KB that represents the size of the memory buffer.
Behavior
If set to -1, the driver does not cache long data in result sets. It is cached on the server. Use this value only if your application retrieves columns in the order in which they are defined in the result set.
If set to 0, the driver caches long data in result sets in memory. If the size of the result set data exceeds available memory, the driver pages the result set data to disk.
If set to x, the driver caches long data in result sets in memory and uses this value to set the size in KB of the memory buffer for caching result set data. If the size of the result set data exceeds available memory, the driver pages the result set data to disk.
