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. 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

My (humble) opinion: If it helps (a lot) in your code quality
(maintenance, architecture aso.) go for it. If not leave as it is. If
you're in the middle perhaps a benchmark will tell. But here is a
problem. I'm willing to do some benchmarks for you, but if a common
server hardware configuration today isn't a problem to know (and perhaps
I can provide such a test bed), knowing what database the users really
use is (at least for me) more or less a 'dangling pointer'. Perhaps we
can do a poll for our users with some questions regarding on this...

hth,

m. th.