假设有一个针对非常大的表运行的查询,它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
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.
缓存工作表时,该表会截断,并且缓存中保留九页以便重用。
When a work table is cached, the table is truncated and nine pages remain in the cache for reuse.
“选择要缓存的表”页中可以选择指定哪些表在本地缓存。
Choose tables to cache page gives you the option of specifying which tables you will cache locally.
“选择要缓存的表”页中可以选择指定哪些表在本地缓存。
Choose tables to cache page gives you the option of specifying which tables you will cache locally.
应用推荐