优势数据库服务器：内存中查询
据我所知，ADS v.10 尝试将查询结果保留在内存中，直到它变得相当大。对于 __output 表和临时表也应该如此。当结果变大时，进行交换。
问题是为查询、工作人员等设置的内存限制是多少？这个限制可以配置吗？
谢谢。
As far as I know, ADS v.10 tries to keep result of query in memory until it is a quite huge. The same should be true for the __output table and for temporary tables. When the result becoming large, swapping stated.
The question is what memory limit is set for a query, a worker, whatever? Could this limit be configured?
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
总体限制由 MAX_CACHE_MEMORY 配置参数控制。我认为目前没有任何配置参数或机制可以根据每个用户来控制它。
一般来说，LRU 方案用于在达到限制时删除旧页面。此外，它使用一种缩放算法来控制每个用户可以获得多少内存，以避免允许一个连接不断获取过多的缓存。
The overall limit is controlled by the MAX_CACHE_MEMORY configuration parameter. I don't think there is currently any configuration parameter or mechanism to control it on a per-user basis.
In general, an LRU scheme is used to remove old pages when the limit is reached. In addition, it uses a scaling algorithm to control how much memory each user can get to avoid allowing one connection to constantly be acquiring overly large portions of the cache.