skip to main content
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
*This connection option can affect performance.
Default
0 (Cursor)
GUI Tab
Performance tab
See Also
See Performance Considerations for details.