This is ideal when the entire resultset is not actually required, since it more effectively uses the available memory.
当实际上并不需要整个结果集时,这将是理想的,因为它能够更有效地使用可用内存。
LPAR2 (also with 4gb of memory) was busier and at times required more memory and occasionally it would page to paging space.
LPAR2(也有4gb的内存)比较忙,有时候需要更多内存,偶尔会把页面交换到分页空间。
This can cut the time required to process queries by as much as 20 percent because more data can be kept in memory, reducing the number of I/O operations to slower mechanical disk drives.
这导致处理查询所需的时间降低了 20%,因为可以在内存中保存更多数据,减少了对缓慢的机械磁盘驱动器的 I/O 操作次数。
应用推荐