Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connection Parameters and Network Protocol Options » Connection parameters

Language connection parameter [LANG] Next Page

LazyClose connection parameter [LCLOSE]

Causes the CLOSE cursor-name database request to be queued, and then sent to the server with the next database request when this parameter is enabled. This eliminates a network request each time a cursor is closed.








When this parameter is enabled, cursors are not actually closed until the next database request. Any isolation level 1 cursor stability locks still apply to the cursor while the CLOSE cursor-name database request is queued.

Enabling this option can improve performance, if your:

Note that in rare circumstances, canceling the next request after the CLOSE cursor-name database request can leave the cursor in a state where it seems to be closed on the client side, but is not actually closed on the server side. Subsequent attempts to open another cursor with the same name will fail. Using LazyClose is not recommended if your application cancels requests frequently.

See also