What Cursor Types Are Supported?
The DataDirect Connect Series Oracle drivers optimize forward-only cursors to pre-fetch multiple records, reducing network traffic and improving performance. Two types of scrollable cursors are supported to allow maximum application flexibility: • Static cursors are ideal for applications that require high levels of concurrency on the database server and require the ability to scroll forwards and backwards through result sets. The DataDirect Connect Series Oracle drivers fully implement the static cursor model and provide options to fine-tune static cursor performance (for example, options allowing you to set how much long textual data is cached). • Keyset-driven cursors are the preferred scrollable cursor model when the application cannot afford to buffer the data from a static cursor. The DataDirect Connect Series Oracle drivers implement a robust keyset-cursor model that works well with dynamic enterprise applications.
