Download HyperSQL User Guide

Properties
Name
Default
Description
SET DATABASE EVENT LOG LEVEL { 0 | 1 | 2 }
Table 12.28. Rows Cached In Memory
Name
Default
Description
hsqldb.cache_rows
50000
maximum number of rows in memory cache
Indicates the maximum number of rows of cached tables that are held in memory.
The value can range between 100-1,000,000. If the value is set via SET FILES then it becomes effective after the
next database SHUTDOWN or CHECKPOINT.
The property is changed via the SET FILES CACHE ROWS nnn SQL command.
SET FILES CACHE ROWS <numeric value>
Table 12.29. Size of Rows Cached in Memory
Name
Default
Description
hsqldb.cache_size
10000
memory cache size
Indicates the total size (in kilobytes) of rows in the memory cache used with cached tables. This size is calculated
as the binary size of the rows, for example an INTEGER is 4 bytes. The actual memory size used by the objects is
2 to 4 times this value. This depends on the types of objects in database rows, for example with binary objects the
factor is less than 2, with character strings, the factor is just over 2 and with date and timestamp objects the factor is
over 3.
The value can range between 100-1,000,000. The default is 10,000, representing 10,000 kilobytes. If the value is
set via SET FILES then it becomes effective after the next database SHUTDOWN or CHECKPOINT.
SET FILES CACHE SIZE <numeric value>
Table 12.30. Size Scale of Disk Table Storage
Name
Default
Description
hsqldb.cache_file_scale
8
unit used for storage of rows in the .data file
The default value corresponds to a maximum size of 16 GB for the .data file. This can be increased to 16, 32, 64 or
128, resulting in up to 256 GB storage size.
SET FILES SCALE <numeric value>
Table 12.31. Size Scale of LOB Storage
Name
Default
Description
hsqldb.lob_file_scale
32
unit used for storage of lobs in the .lobs file
The default value represents units of 32KB. When the average size of individual lobs in the database is smaller, a
smaller unit can be used to reduce the overall size of the .lobs file. Values 1, 2, 4, 8, 16, 32 can be used.
222