Advantage Database Server: In-Memory Queries
As far as I know, ADS v.10 tries to keep the query result in memory until it gets pretty huge. The same should be true for the __output table and for temporary tables. When the result becomes significant, an exchange is exchanged.
The question is what is the memory limit set for the query, working what? Can this limit be adjusted?
Thanks.
a source to share
The total limit is controlled by the MAX_CACHE_MEMORY configuration parameter . I don't think there is currently any configuration setting or mechanism to manage it for each user.
In general, the LRU scheme is used to delete old pages when a limit is reached. In addition, it uses a scaling algorithm to manage the amount of memory each user can get to prevent one connection from constantly getting too large portions of the cache.
a source to share