|
[Sorter]
|
Description
|
Factory value
|
Access mode
|
|---|---|---|---|
|
BlockSize
|
Block size (in bytes) of the external sorter files.
Follow the value with K (to specify a value in KB), M (to specify a value in MB), or G (to specify a value in GB).
For example: Sorter.BlockSize=64K
If set to 0, the database block size is used.
|
0
|
RW/
Startup |
|
MaxCacheUsePercent
|
Maximum percentage of cache pages that can be used for sorting.
Possible values range from 10 (10%) to 50 (50%).
For example, if the IndexFile.CacheSize parameter is set to 20M (20MB), and if MaxCacheUsePercent is set to 25, a maximum of 5MB of memory is available for sorting.
If you specify both the MaxCacheUsePercent and MaxMemPerSort parameters, the values must be compatible. You get an error message if the following calculation is not true:
MaxCacheUsePercent x CacheSize >= MaxMemPerSort
|
25
(25%) |
RW/
Startup |
|
MaxFilesPerSort
|
Maximum number of files used for one sort (sorting the result set of one query).
|
7
|
RW/
Startup |
|
MaxFilesTotal
|
Maximum number of files used for sorting.
|
5000
|
RW/
Startup |
|
MaxMemPerSort
|
Maximum memory (in bytes) that is available for one sort (sorting the result set of one query).
Follow the value with K (to specify a value in KB), M (to specify a value in MB), or G (to specify a value in GB).
The minimum value is Indexfile.Blocksize * MaxFilesPerSort.
The value of this parameter must not exceed the amount of memory available to the sorter, see MaxCacheUsePercent for more information.
|
MaxFilesPerSort * 256KB
|
RW/
Startup |
|
SorterEnabled
|
If set to yes, the external sorter is used.
The external sorter algorithm is used for sorting processes that do not fit in main memory.
|
yes
|
RW/
Startup |
|
TmpDir_[l... N ]
|
Name of the directory or directories that contain temporary files that are created when using the external sorter algorithm.
The N signifies the file directory number, if more than one directory is used to store the temporary file. For example:
TmpDir_1=c:\soldb\temp1
TmpDir_2=d:\soldb\temp2 The path must use the conventions of your operating system. For example, in Windows environments, if the path contains white space characters, the path must be enclosed in double quotation marks. If the server runs on a UNIX operating system, path separators must be slashes instead of backslashes.
|
"."
(The directory from which the server was started.)
|
RW/
Startup |