Hello Alexey,
> Hi,
>
> I remember I answered incorrectly that time :)
>
> TempCacheLimit is always per server instance.
Makes sense. Thanks for the clarification. :-)
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager,
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
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
Hi,
I remember I answered incorrectly that time :)
TempCacheLimit is always per server instance.
For Classic it means it is allocated per each connection (since each
connection has own server process), for SuperClassic and SuperServer
temp space will be shared between connections, since
Hi Thomas,
> From what i can read on the internet TempCacheLimit, is per server
> process, and not per attachment.
In SuperServer architecture, right, but if I remember correctly, you
have mentioned in one of your first posts that you are using
SuperClassic, right?
>
Hey
From what i can read on the internet TempCacheLimit, is per server process, and
not per attachment.
http://firebird.1100200.n4.nabble.com/TempCacheLimit-td4309475.html
http://firebird.1100200.n4.nabble.com/TempCacheLimit-td4309475.html
Hi,
> Thanks for the advise Thomas I will increase the value.
> After we changed TempCacheLimit to 567108864, we saw the problem once
> under heavy load - for a very sourt perio this time.
Increased TempCacheLimit value as a side-effect of serving more temp
stuff through RAM instead of
> Hey Thomas
> Thanks for the answer. The command output is this:
> Max cpu time unlimited unlimited seconds
> Max file size unlimited unlimited bytes
> Max data size unlimited unlimited bytes
>
Hey Thomas Thanks for the answer. The command output is this:
Max cpu time unlimitedunlimitedseconds
Max file size unlimitedunlimitedbytes
Max data size unlimitedunlimitedbytes
Max
