Part 2: The 32-Bit/64-Bit Drivers : The Sybase Wire Protocol Driver : Connection Option Descriptions : Select Method

Select Method
Attribute
SelectMethod (SM)
Purpose
Determines whether database cursors are used for Select statements.
Valid Values
0 | 1
If set to 0 (Cursor), database cursors are used. In some cases performance degradation can occur when performing large numbers of sequential Select statements because of the amount of overhead associated with creating database cursors.
If set to 1 (Direct), Select statements are run directly without using database cursors, and the data source is limited to one active statement.
Notes
Default
0 (Cursor)
GUI Tab
Data Source Configuration through a GUI
See Also
See Performance Considerations for details.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.