A Study Into High Performance Data Query Key Techniques In E-Commerce Web Sites

Along with the fast development of Web technology, the economic globalization and profound politic, economic and social changes, the consumers spending power has increased and market demands diversified, leading fierce competition among companies. Electronic commerce has made great advance in these conditions. However, opportunities always comes with challenges, and while online business are developing very quickly, the performance of e-commerce Web sites become a significant factor affecting the companies' competitiveness.This paper begins with an introduction four factors influencing a Web site's performance: database queries, the response speed of web server, the data transfer between web server and browser and displaying Web pages in the browser, followed by an analysis of the current research work on database query optimization and software based Web site performance optimization. Furthermore, it uses an e-commerce sample - an online book store to study Web site performance optimization techniques. The author analyzed the online book store's requirements, carried out functional design, architectural design and database design using UML.A challenge of an online book store is how to find book information a user requires among masses of database data and transfer such information onto user's interface. Considering that most of the transactions are information queries other than updates or changes, the database design of an online book store should maximize query speed. This paper discussed a number of methods for improving online book store's performance, including using index, optimizing SQL sentences, using space for speed in database table design, dividing large book information table into smaller tables, and using Ajax local renovation & asynchronous read technology and so on.The online book store's Web pages can be classified into 6 categories with different accessing rates. Obviously, maximum Web site performance gain can be achieved by optimizing the Web pages with high access rates. The author selected the page for current most popular books which should have high access rate, and implemented the page in three different ways: no cashing, cashing with SqlDatabaseSouce control and cashing with post-cache substitution technique. The performance results show that when proper cashing is applied, the performance gain can be very large (up to 80 times).