CONNECT data-source-name -dt ODBC
-Dsrv query-tuning-option1,value1 -Dsrv query-tuning-option2,value2. |
CONNECT data-source-name -dt ODBC -Dsrv
query-tuning-option1,value1,query-tuning-option2,value2. |
Option
|
Description
|
qt_lookahead qt_no_lookahead
|
Specifies whether the DataServer uses lookahead or standard cursors. To generate efficient queries, qt_lookahead is the default in the following cases:
Statements that use NO-LOCK
Statements that use SHARE-LOCK with transaction isolation level set to read uncommitted
Specify qt_no_lookahead for query behavior that is consistent with an OpenEdge database.
|
qt_separate_connection qt_no_separate_connection
|
Specifies whether each cursor should use a separate connection to the ODBC data source. The default is qt_no_separate_connection, which provides behavior that is consistent with OpenEdge.Specify qt_separate_connection to use a separate connection. Executing cursors in separate connections can improve performance because the DataServer does not have to restart the cursors.
|
qt_cache_size, integer
|
Specifies the size in bytes of the cache used by lookahead cursors. A larger cache size can improve performance for queries that return a large number of records because the DataServer might need fewer SQL statements to get the results.Minimum: The DataServer always caches at least one record.Maximum: NoneDefault: 30000
|
CONNECT holder -db infdb -dt ODBC -ld demo -U user -P password -Dsrv qt_separate_connection,qt_debug,EXTENDED.
|