Research On The Improvement Technology Of Database Access Performance For B/S Architecture Network System And Its Application

With the continuous progress of social information,global information has become an irresistible trend.In order to meet the needs of the current business,the network system based on the B / S architecture have impacted the network system based on the traditional C / S architecture.The amount of information in today's society is exploding.Enterprise-class B / S applications are faced with enormous operational pressures.There are more and more users accessing the system.The data stored in the database is getting bloated.The pressure of network data transmission is getting bigger and bigger.This series of status to the database access performance has brought great challenges.The traditional database access technology has been unable to meet the needs of today's users.How to ensure the smooth experience of the user,but also to ensure the stability of the system and the correctness of business implementation,which is the main problem that developers need to solve at present.This paper reviews the relevant literature,summarizes the development status of B/S network system and the research status of database access performance optimization technology.On this basis,we study the relevant theoretical basis and ideological principles,and analyze the performance of B/S architecture network system.In this paper,we study the current computer storage hierarchy,and determine the bottleneck of database access performance.From the point of view of program design,the optimiza tion criterion of high performance price ratio is put forward.According to the optimization criteria,this paper studies the database access performance optimization related technologies,including database connection pool technology,SQL paging technology,database index technology,database data cache technology.In this paper,the basic principles of these technologies are studied.Combined with the Spring framework,the optimization technique is applied to practical system.This paper summarizes the application of optimization technology,and then uses the JMeter test tool to test the efficiency of data access.The results show that the application of database connection pool technology,SQL paging technology,database index technology,database data caching technology can greatly reduce the response time of the system,and effectively improve the efficiency of database access.