Django框架Web数据查询分页技术研究

为了探索Django框架下Web数据查询分页的实现方法及性能,本文先对Web数据查询分页的执行过程和在其它框架下常用的分页方法进行了分析研究.在此基础上,提出了在Web服务层和在数据库服务层分页两种方案在Django框架下实现的几种具体方法,分别是利用缓存和Sessions实现在Web服务层分页,利用存储过程和自定义Manager方法实现在数据库服务层分页.最后,对这几种实现方法进行了测试比较,发现在网站数据量较小时几种方法性能差别不大,当数据量较大时在数据库服务层分页方法性能较为优越.

Research on query pagination technology for web data based on django framework

In order to explore the methods and properties of Web data query pagination in the Django framework,this paper first analysis the implementation processes of Web data query pagination and the methods of paging commonly used in other frameworks.On this basis,puts forward several implement methods of paging in the Web service layer and paging in database service layer in the Django framework,which are paging in the Web service layer by using the cache and Sessions and paging in the database service layer by using stored procedures and user-defined Manager method.Finally,these methods are tested and compared,find that when the data of website is little the performance of these methods is not very different,but when the data of website is huge the method of paging in database service layer is superior.