JSP + SQL Server Precompiled and Stored Procedures Realize the Rapid Update and Statistics of Commodity Information

Abstract

In the era of big data, online shopping is becoming more and more perfect. In e-commerce, how to ensure the versatility of e-commerce systems, realize the rapid and safe updating and statistics of large quantities of commodity information, shorten the database access time, and accelerate the response speed of pages are the functions that merchants and customers need urgently. This paper uses JSP technology with excellent mobility to develop applications, and uses SQL Server precompilation and stored procedure technology to solve the fast and security of commodity information updating and statistics. Through the example verification and performance test, the method improves the database access speed, optimizes the database access performance, reduces the response time of the electronic mall system, and meets the urgent needs of customers and businesses technically, which is worthy of popularization and application.