Subject Re: [Firebird-general] Re: [] Firdbird 2.0 vs the World
Author Dmitry Yemanov
= m. Th = wrote:
>
> b. SortMemBlockSize = 1048576 (ie. 1 MB) According with the amount
> of RAM and with the Db sizes today perhaps is better to bump it at
> (least) 4 MB. My value: 16777216 (16MB)

It saves you 15 memory allocations per big sort, but also wastes 16MB of
memory per every small sort. I don't think this value requires a bump,
although in some cases it could allow a bit better performance.
Honestly, I often think about making it hardcoded (not configurable).


Dmitry