However, as test 8 showed, utilizing NLI with aggressive page cleaning can shorten the elapsed time substantially.
不过,test8表明,将NLI与积极的页清除一起使用的时候,可以大大减少耗时。
This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.
这个参数决定缓冲池中脏页的阈值百分比,当脏页达到这个百分比时,就会启动页清除。
The rate of page cleaning, or the total absence of it, can cause large differences in timings which can make performance comparisons misleading.
页清除率,或者说总缺页率,可能导致计时上的很大不同,使得性能比较容易产生误解。
In fact, as shown by tests 6 and 7, if page cleaning is not done aggressively, the total elapsed time for Iisert plus commit can be longer with NLI.
实际上,test6和7已表明,如果没有积极地进行页清除,那么在使用NLI的情况下,Insert加上提交所耗费的总时间要更长一些。
Setting this variable to on provides a more proactive approach to page cleaning than the default approach (based on CHNGPGS_THRESH and LSN gap triggers).
通过将这个变量设置成on,可以为页清除提供一种比缺省方法(基于CHNGPGS_THRESH和LSN间隙触发器)更积极的方法。
However, with the more aggressive page cleaning in test 8, performance was improved substantially, mostly through the Commit time being reduced by over five seconds.
然而,当test8中采用了更积极的页清除时,性能就大大提高了,这主要是因为Commit的时间缩短了超过5秒钟。
For more information, visit our Cleaning and Cleanliness page and make sure you read our page on Salmonella.
欲了解更多信息,请访问我们的清洁和清洁页面并确认您阅读我们的网页上沙门氏菌。
If your stitched design needs cleaning or pressing, please refer to the back page.
如果你的绣图需要清洁和熨烫,请参考后面一页。
If your stitched design needs cleaning or pressing, please refer to the back page.
如果你的绣图需要清洁和熨烫,请参考后面一页。
应用推荐