Some Sybase IQ parameters directly affect latency statistics.
Enabling the following Sybase IQ network communication parameters can directly affect latency calculations by reducing the number of requests between the client and the server.
|
Sybase IQ Parameter |
Components |
Description |
|---|---|---|
|
LazyClose [LCLOSE] |
Sybase IQ, and therefore RAPStore |
Causes the CLOSE cursor-name database request to be queued, then sent to the server with the next database request. This eliminates a network request each time a cursor is closed. This option is disabled by default. You may want to enable this option if your network exhibits poor latency (that is, it takes the subscriber a long time to write messages to the RAPStore). Note: Enabling LazyClose is not recommended if your application cancels requests frequently.
|
|
PrefetchOnOpen |
Sybase IQ, and therefore RAPStore |
ODBC parameter, disabled by default. When this parameter is enabled, a prefetch request is sent with a cursor open request, thereby eliminating a network request to fetch rows each time a cursor is opened. |