本文已被:浏览 1810次 下载 4721次
Received:October 02, 2014 Revised:November 28, 2014
Received:October 02, 2014 Revised:November 28, 2014
中文摘要: 针对MongoDB在大数据量情况下, 内置的skip操作会变的很慢, 数据库的分页查询效率成为影响数据库访问性能提高的重要问题. 从分析MongoDB内置的skip-limit分页方法的优点和缺点及影响分页查询速度的关键因素入手, 提出一种新的where-limit数据分页方法. 通过改变查询文档的规则及使用合理的索引来提高分页效率. 实验结果证实, 优化后的查询方法在实现分页显示的操作中速度有明显的提高.
Abstract:Under large amount of data the skip operation made data paging very slow, how to improve the performance of data paging efficiency became an import issue for MongoDB. We came up a where-limit data paging method from analysis of the built-in skip-limit MongoDB data paging method's advantages and disadvantages, and the key factors affecting the speed of the data paging. Changed the rules of query document and used reasonable indexes can improve data paging efficiency. The experimental results confirmed that the optimized query methods in pagination operations could significantly improved the speed.
keywords: MongoDB data paging index optimization
文章编号: 中图分类号: 文献标志码:
基金项目:陕西省教育厅科研计划项目(4JK2087)
引用文本:
王振辉,王振铎.MongoDB中数据分页优化技术.计算机系统应用,2015,24(6):244-247
WANG Zhen-Hui,WANG Zhen-Duo.Data Paging Optimization in MongoDB.COMPUTER SYSTEMS APPLICATIONS,2015,24(6):244-247
王振辉,王振铎.MongoDB中数据分页优化技术.计算机系统应用,2015,24(6):244-247
WANG Zhen-Hui,WANG Zhen-Duo.Data Paging Optimization in MongoDB.COMPUTER SYSTEMS APPLICATIONS,2015,24(6):244-247