Reduce Query Processing Latency

The query processing layer in Adaptive Server 15.7 enables multiple client connections to reuse or share dynamic SQL lightweight procedures (LWPs).

Adaptive Server uses the statement cache to store dynamic SQL statements converted to LWPs. Because the statement cache is shared among all connections, dynamic SQL statements can be reused across connections. These statements are not cached:

Use the streamlined dynamic SQL or enable functionality group configuration parameters to enable this feature.

See "Memory Use and Performance" in the Performance and Tuning Series: Basics and "Setting Configuration Parameters" in the System Administration Guide, Volume 1.