13.1 Tuning to improve processing performance

This section explains how to tune the HADB server in order to improve its processing performance.

For details about the tuning method for improving each command's processing performance, see 13.3 Tuning to shorten command execution time.

Organization of this section

• 13.1.1 Pre-reading of range indexes

• 13.1.2 Re-evaluating the defined range indexes

• 13.1.3 Re-evaluating the defined text indexes

• 13.1.4 Reducing the HADB server startup time (by applying HugePages)

• 13.1.5 Preventing SQL statement execution wait status from occurring

• 13.1.6 Reducing the SQL statement processing time

• 13.1.7 Expanding the user log buffers

• 13.1.8 Expanding the initial size of user log files

• 13.1.9 Re-evaluating the trigger size for reducing user log files

• 13.1.10 Preventing automatic extension of DB areas

• 13.1.11 Changing the file configuration of the work table DB area

To Page Top