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, IB LogManager, Database Health Check, Tuning etc. > 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 there is the single > server process. > > Regards, > Alexey Kovyazin > IBSurgeon > www.ib-aid.com > > > > > On 02.09.2017 20:46, Thomas Steinmaurer [email protected] > [firebird-support] wrote: >> >> 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? >> >> > http://firebird.1100200.n4.nabble.com/TempCacheLimit-td4309475.html >> >> Talking about SuperServer. >> >> > >> https://www.mail-archive.com/[email protected]/msg10199.html >> >> Talking about SuperClassic with answers that it is per connection. >> >> > >> > >> > I believe I have found the statements that caused the problem, first >> one >> > was executede about 400/second and contained a union, that was replaced >> > by union all in the hope that would eliminate the need for temp cache. >> >> UNION vs. UNION ALL. UNION is removing duplicates, thus some sort of >> applying DISTINCT with first sorting to remove duplicates is applied. >> >> DISTINCT, sorting, group by (internally first doing a sort) will >> internally produce temporary data. >> >> > The second statement is a really nasty dynamically build common table >> > expression containing upwards of 10 union.. Here we are in the process >> > of moving this search to Elastisearch. >> > >> > We just purchased FB TraceManager at our company to weed performance >> > issues - Thanks for a great product : ) >> >> Great to hear. Thanks. :-) >> >> -- >> With regards, >> Thomas Steinmaurer >> http://www.upscene.com/ >> >> Professional Tools and Services for Firebird >> FB TraceManager, IB LogManager, Database Health Check, Tuning etc. >> >> > >
