Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SUBSYSTEM SQL LATTE

The Latte engine is a disk based container for rapid sorting of data used extensively in SQL query temporary data tuple sorting. This subsystem has multiple options for performance and capacity configuration and accepts the following options:

  • MAX_MEMORY <memory> - maximum advisable memory per environment.
  • MAX_STORE <limit> - limits the per-connection amount of temporary disk space available for SQL query execution. Default is 512 GB. Max is 128 TB. Minimum is 2 GB. Setting this value too small could cause some SQL queries to fail with LT_ERR_STOREFULL (-16306). This option can be dynamically configured without restarting the server.
  • CACHE_BLK <blocks> - default number of blocks in the temporary cache of a table.
  • NONE - This option is used in conjunction with the tamper-proof settings file under the server. When specified, the entire SUBSYSTEM SQL LATTE cannot be overridden in ctsrvr.cfg

Example

SUBSYSTEM SQL LATTE

{

MAX_MEMORY 64M

MAX_STORE 1000 GB

}

History

V10.3 - Latte replaces the original MM temporary table sorting engine in prior releases.

V11.6.0 - MAX_STORE added.

TOCIndex