假设有一个针对非常大的表运行的查询,它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.
如果您的网站上的用户有每个会话的多个页视图,您的页面的许多重复使用相同的脚本和样式表,有缓存的外部文件一更大的潜在好处。
If users on your site have multiple page views per session and many of your pages re-use the same scripts and stylesheets, there is a greater potential benefit from cached external files.
工作表被删除后,这两页可能会保持分配状态并返回到工作表缓存中。
When a work table is dropped, two pages may remain allocated and they are returned to the work table cache.
应用推荐