| Page is a problem for each Web application to face.For small-scale applications,some very rough approaches can be taken,for example it is simple and a better solution to extract the data from data source directly for each request;while for larger-scale ones,a large number of database access are involved in each page,the paging query efficiency of database has become an important issue to improve performance of database access.This article has research on multiple query optimized algorithms which are widely used and display methods of various page.The optimized principle of SQL statements is analized through optimizer in query optimization,multi-join query most frequently used at present is mainly studied in the text.On the other hand,the advantages and disadvantages of various paging methods are discussed to point out some basic ideas and interfacial descriptions of extended paging methods.Then the programmings of data record displayed pagely in Web database are discussed through a characteristic example,and source codes of some procedures are given combining with paging queries of orders in procurement and tender system.The results show that this method can achieve the merits with the separation of display logic and business logic,reuse of codes,and nothing to do with the specific database.In addition,the paging technology discussed in the article has been applied to the practical applicational systems developed by the author.After testing,the program can reflect a better system performance.For example the average response time is shortest when the page query is carried out among 50,000 records in the database.And it has smaller relevance with the specific database, good common,and efficient implementation,with better improve in robustness, security, stability and portability relating to other ways. |
