| Subject | Re: [firebird-support] Re: Sort error No free space found in temporary... |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2017-09-03T18:15:22Z |
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.thomas@... [firebird-support] wrote:
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.thomas@... [firebird-support] wrote:
HeyThanks 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.