Using Asynchronous Frameworks and Database Connection Pools to Enhance Web Application Performance in High-Concurrency Environments

Modern web applications are experiencing exponential expansion in terms of the number of users and data volume, which puts increased demand on the system's capacity for high concurrent processing. This paper aims to explore the use of asynchronous frameworks and database connection pools in high-concurrency environments to significantly enhance the performance of web applications. Asynchronous framework enables applications to handle requests in a non-blocking manner, effectively releasing thread resources and improving the system's concurrency processing capability. Simultaneously, database connection pool optimizes the management of database connections resulting in reduced overhead of connection creation and destruction, thereby alleviating the burden on the database. This paper elucidates the significant impact of adopting asynchronous frameworks and database connection pools on improving system performance. The design adopts Springer WebFlux, an asynchronous framework, along with the proper configuration and utilization of database connection pool design, which exhibits lower average response time, higher throughput, better stability, and outstanding performance in high-concurrency scenarios. The developed model is tested, and it exhibits better results than synchronous models and outperforms asynchronous models without connection pool. This research holds practical guidance for enhancing web application performance and optimizing user experience.

I. Introduction

In today's digital era, with the rapid growth of web applications and services in terms of user scale and data volume, the demand for high concurrency processing capability in systems has become increasingly urgent. Users expect fast and seamless experience when accessing web applications ^[1]. However, achieving this goal becomes more challenging in the face of large-scale concurrent requests and complex data operations.