Subject Re: [Firebird-general] Re: [] Firdbird 2.0 vs the World
Author Ann W. Harrison
Dmitry Yemanov wrote:
> = 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.

Oh, I thought that was the limit at which a run was written from memory
to disk. Apparently not.


Best regards,


Ann