Speed Sort (-TB) parameter
- -TB is the block size (in kilobytes) is used to improve the sorting performance.
- The speed sort block size is allocated when sorting records for queries and when rebuilding indexes
- -TB improves sort performance at the cost of disk space. By increasing the block size, Progress will sort records faster, but it will also use more RAM memory and disk space in the process.
- When system memory or available disk space is limited, then you may wish to lower the block size down, perhaps even to 1, which will then slow down the sorting process but it will allow normal performance of other processes on the system.
- In Progress 9 -TB parameter's default is 2KB, and its maximum is 31K.
In OpenEdge 10 -TB default is 8K, and in 10.2B06 its maximum increased from 31 to 64 for index rebuild.
In OpenEdge release 11 -TB default remains 8K and its maximum 64K,
Merge Number (-TM) parameter
- -TM represents the number of blocks (or -TM streams) to be simultaneously merged during the sort process, improving performance at the cost of memory usage
- The Merge Number is used to increase the speed of the merge phase in the sorting process, with the cost of increased memory usage.
- -TM parameter's default is 5 blocks, and its maximum is 32 blocks in Progress 9 and also in OpenEdge 10 and 11 releases.
To tune -TB and -TM parameters, if there is plenty of RAM memory and disk space available on the system, then increasing -TM and -TB parameters up to their maximum will provide the best speed of the sorting process.
If the system RAM memory or disk space is limited, then reducing -TM and -TB parameters is advisable, so that they don’t slow down other processes on the system by taking up all available system resources.
