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.