APT_TSORT_NO_OPTIMIZE_BOUNDED

Set the APT_TSORT_NO_OPTIMIZE_BOUNDED environment variable to prevent the optimization of bounded length fields by the tsort operator.

By default the tsort operator optimizes bounded length fields by converting them to variable length before the sort and converts them back to bounded length after the sort. For records with many bounded fields where the actual size of the data is much smaller than the upper bound the optimization results in a large reduction of disk I/O.

For records that do not have large differences between data size and upper bound of bounded length fields, this optimization often causes slower sort performance. In this situation, set the APT_TSORT_NO_OPTIMIZE_BOUNDED environment variable to disable the optimization.

Setting the APT_TSORT_NO_OPTIMIZE_BOUNDED environment variable when APT_OLD_BOUNDED_LENGTH is set has no effect as APT_OLD_BOUNDED_LENGTH also disables the bounded length optimization.