MongoDB分页技术改进与优化  

Improvement and Optimization on MongoDB Paging Technology

作　　者：王振辉[1] 王振铎[2] 王静婷[1] 

机构地区：[1]西安翻译学院工程技术学院,陕西西安710105 [2]西安思源学院电子信息工程学院,陕西西安710038

出　　处：《计算技术与自动化》2015年第3期127-130,共4页Computing Technology and Automation

基　　金：陕西省教育厅科研计划项目资助(14JK2087)

摘　　要：随着数据量的不断增加,使用MongoDB数据库内置的skip和limit组合分页算法效率低下,成为影响数据库访问性能提升的重要问题。从分析影响分页查询速度的关键因素入手,提出细粒度查询改进算法和where-limit算法。通过理论推导和与原算法的实验结果的比较,分析了两种新算法使用场景和优缺点。将两种算法应用于实际Web2.0日志系统应用中,取得了较好的效果。最后,对影响数据分页的其它因素进行了探讨,以更好的提高Web应用性能。With the increasing amount of data,the efficiency of using the built-in mongo database skip and limit combi-nation paging algorithm is low,which has become an important issue affecting the performance of database access.From the analysis on the key factors affecting the speed paging query,this paper proposed the fine-grained query improved algorithm and where-limit algorithm.Through theoretical deduction and comparison of the experimental results with the original al-gorithm,this paper analyzed the usage scenarios and the advantages and disadvantages of two kinds of new algorithm.The two algorithms were applied to practical application of Web2.0 logging system,and achieved good results.Finally,other factors affecting the data pages were discussed in order to improve Web application performance better.

关 键 词：MONGODB 数据分页 索引 查询 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]