Using Asynchronous Frameworks and Database Connection Pools to Enhance Web Application Performance in High-Concurrency Environments
Lei Ju, Amit Yadav, Asif Khan, Abhishek Pratap Sah, Dakshina Yadav · 2024
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.