ASA SQL User's Guide
  Monitoring and Improving Performance
    Top performance tips

Reduce the number of requests between client and server

If you find yourself in a situation where your:

• network exhibits poor latency

• application sends many cursor open and close requests

you can use the LazyClose and PrefetchOnOpen network communication parameters to reduce the number of requests between the client and server and thereby improve performance.

For information about these parameters, see the LazyClose connection parameter [LCLOSE] and the PreFetchOnOpen communication parameter.