buppcpp wrote:

> When does the sort memory usage come into play?
>
> I have SortMemUpperLimit = 67108864 in my configuration, but my memory
> usage never goes above my DefaultDbCachePages settings.
>

The clues are "sort memory" and "upper limit". When possible, Firebird
performs sorts in memory, without creating temporary files for
intermediate results. That can use a lot of memory, so there's a
configuration parameter that allows you to limit the amount of memory
allocated to a sort. That parameter has no effect on the amount of
memory preallocated for anything or the amount of memory used for
purposes other than sorting.


Regards,


Ann