Version 6.3.13 for UNIX
 —  Operations  —

Tuning SQL Database Access

By default, the Natural SQL driver manages a table with the 16 most recently used Natural statements. All statements in this table are marked as prepared, which indicates that the statement can be executed immediately without being compiled by the database system.

To ensure maximum performance, the dynamic parameters SQLRELCMD and SQLMAXSTMT are provided. These parameters configure the handling of the SQL driver's statement table. Note that these parameters are not profile parameters.


SQLRELCMD

This parameter determines when commands are to be released from the SQL statement table.

Possible values:

Top of page

SQLMAXSTMT

This parameter determines the size of the statement table.

Possible values:

If you set the SQLMAXSTMT parameter, keep the following in mind:

Top of page

Example

To set the above parameters dynamically, enter them when starting Natural:

natural sqlrelcmd=never sqlmaxstmt=40

Natural will then start with a statement table size of 40 and the statement table will only be cleared when Natural is terminated.

Top of page