Hi all,

trying to tune up the performance of FB 1.5, we have found

SortMemBlockSize

and

SortMemUpperLimit

parameters in the firebird.conf configuration file.

They seem to be used for so called in-memory sorting (used belike by
commands GROUP BY, ORDER BY...)

What we really want to know is how these two parameters interact
together and what is the ideal setting for them.

We are running FB under 64bit Linux (AMD Athlon) with 2GB RAM.

regards

Petr