摘要
针对MySql在多表分页查询中由于数据量大导致效率无法满足系统要求,本文经过深入研究和分析发现,常用的表union操作需要耗费大量的时间,成为影响数据库访问性能提高的关键因素.为了提升数据库类似操作的查询效率和用户体验,提出一种新的多表查询算法,该算法通过精确定位分表的技术避免多表的union操作以及使用合理的索引来提高查询效率.通过大量的实验证实,优化后的查询算法在实现大数据量的多表union分页查询操作中效率有明显的提高.
Under large amount of data the union operation makes data paging very slow, how to improve the performance of data paging efficiency becomes an import issue for MySql. This paper proposes a new data paging algorithm from analysis of union operation in MySql data paging method＇s advantages and disadvantages, and the key factors affects the speed of the data paging. By avoiding union operation in multi-table query and using indexes it improves query efficiency and reasonable. The experimental results confirms that the optimized query methods in pagination operations could significantly improve the speed.
出处
《计算机系统应用》
2016年第8期171-175,共5页
Computer Systems & Applications
基金
北京市自然科学基金(4131001)
北京市属高等学校创新团队建设与教师职业发展计划(IDHT20130502)
