skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Oracle Driver : Connection Option Descriptions : Optimize Long Performance
  
Optimize Long Performance
Attribute
OptimizeLongPerformance (OLP)
Purpose
Allows the driver to fetch Long data directly into the application’s buffers rather than allocating buffers and making a copy. This option decreases fetch times on Long data; however, it can cause the application to be limited to one active statement per connection.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver fetches Long data directly into the application’s buffers rather than allocating buffers and making a copy.
If set to 0 (Disabled), the driver does not fetch Long data directly into the application’s buffers.
Notes
*If this option is enabled, the Default Buffer Size for Long/LOB Columns option is ignored.
*This connection option can affect performance.
Default
0 (Disabled)
GUI Tab
Performance tab
See Also
See Performance Considerations for details.