1.1.1

COMPACTIONTHRESHOLD
Sets the threshold for the amount of "garbage" data that can exist in the oplog before SQLFire initiates automatic
compaction. Garbage data is created as DML operations create, update, and delete rows in a table. The threshold
is defined as a percentage (an integer from 0–100). The default is 50. When the amount of "garbage" data exceeds
this percentage, the disk store becomes eligible for auto-compaction if AUTOCOMPACT is enabled.
TIMEINTERVAL
Sets the number of milliseconds that can elapse before SQLFire asynchronously flushes data to disk.
TIMEINTERVAL is only used for tables that were created using the asynchronous option in the persistence
clause of the CREATE TABLE statement. See CREATE TABLE on page 491. The default value is 1000
milliseconds (1 second).
WRITEBUFFERSIZE
Sets the buffer size in bytes to use when persisting data to disk. The default is 32768 bytes.
QUEUESIZE
Sets the maximum number of row operations that SQLFire asynchronously queues to disk. After this number
of asynchronous operations are queued, additional asynchronous operations block until existing writes are flushed
to disk. A single DML operation may affect multiple rows, and each row modification, insertion, and deletion
is considered a separate operation. The default QUEUESIZE value is 0, which specifies no limit.
dir-name
The dir-name element defines the host system directories to use for the disk store. It contains one or more
single dir-name elements, made up of:
•
The directory specification, provided as the text of the dir-name element.
• An optional integer value that specifies the maximum amount of space, in megabytes, to use for the disk store
in that directory. By default, there is no limit. The space used is calculated as the combined sizes of all oplog
files in the directory.
You can specify any number of dir-name subelements in a CREATE DISKSTORE statement. The data is
spread evenly among the active disk files in the directories, keeping within any limits you set.
Use different disk-dir specifications for different disk stores. You cannot use the same directory for the same
named disk store in two different members.
Example
This example uses the default base directory and parameter values to create a named disk
store:
CREATE DISKSTORE STORE1
This example configures disk store parameters and specifies a storage directory:
CREATE DISKSTORE STORE1
MAXLOGSIZE 1024
AUTOCOMPACT TRUE
ALLOWFORCECOMPACTION FALSE
COMPACTIONTHRESHOLD 80
TIMEINTERVAL 223344
WRITEBUFFERSIZE 19292393
QUEUESIZE 17374
('dir1' 456)
481
SQL Language Reference