Subject Re: TempCacheLimit, how it is works?
Author Dmitry Yemanov
13.07.2013 0:10, trskopo wrote:
>
> Suppose sql statement issued like this :
>
> select * from table where field = 0
>
> If this statement cached by TempCacheLimit,

There's no sorting here, so TempCacheLimit cannot be applied.

> is memory consumption use by
> TempCacheLimit released after statement finished or remain?

Released.

> Also in Super Classic setting, TempCacheLimit shared or applies for each
> connection?

This limit is per process, so shared.


Dmitry