Hi,
If you have big sort files (you can check their existence manually in
temp folder or use HQbird FBBDataGuard to monitor them for you),
increasing TempCacheLimit to fit all of them can speed up sorting
queries (with GROUP BY and ORDER BY, for example).
However, the better approach is to decrease record sets which should be
sorted.
For example, many developers use ORDER BY for internal processing in
stored procedures - usually it can be simply removed.
Regards,
Alexey Kovyazin
IBSurgeon
On 03.09.2017 20:47, kragh.tho...@yahoo.com [firebird-support] wrote:
Hey
Thanks for the clarification, that is also the only explanation that
made sense to me, after i had a look at the optimized config published
at ib-aid.com.
Alexey perhaps you can answer this, is there anything to gain from
configuring TempCacheLimit to use 2, 4 or 6Gb? Or perhaps more
important could this have an negative effect? Of course provided that
the server has plenty of RAM.