|
[Sorter]
|
Description
|
Factory value
|
Access mode
|
|---|---|---|---|
|
BlockSize
|
Block size of the external sorter files. With the factory value 0, the database block size is used.
|
0
|
RW/
Startup |
|
MaxCacheUse
Percent |
This parameter sets the maximum percentage of cache pages that can be used for sorting. The valid values range from 10% to 50%.
For example, if the IndexFile.CacheSize parameter is set to 20MB, and if MaxCacheUsePercent is 25, a maximum of 5MB of memory is available for sorting.
If you specify both the MaxCacheUsePercent and the MaxMemPerSort, the values must be compatible. You get an error message if the following is not true:
MaxCacheUsePercent x CacheSize >= MaxMemPerSort
|
25
(that is, 25 percent)
|
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
|
This parameter sets the maximum memory in bytes that is available for one sort (sorting the result set of one query).
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.
|
MaxFilesPer
Sort * 256kB |
RW/
Startup |
|
SorterEnabled
|
This parameter enables or disables the usage of the external sorter. The external sorter algorithm is used for sorting processes that do not fit in main memory.
|
Ye s
|
RW/
Startup |
|
TmpDir_[l... N ]
|
This parameter defines the name of the directory or directories that contain temporary files 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 Note When this parameter is specified in the configuration file, the external sorter algorithm is enabled.
|
Defaults to ".",
(The current directory, that is, the directory from which the server was started.)
|
RW/
Startup |