Common Database Performance Problems in Web Application
Most online applications of scale are backed by some form of relational or non-relational database and it can be easily said that backbone of any modern web application is its data. As a result, the database is critical to the functionality and performance of the application and should not come as a surprise that it is the biggest source of performance issues for web applications. The problems can occur at many places, the application code might be accessing the database inefficiently, database connection issues or database itself might need tuning. In this blog, I will be focusing mainly on database performance issues that can occur on application server (business logic) side. The web application can be JAVA based, PHP based or ASP.NET based but the core of the issue would be same. Application code making excessive database queries This performance anti pattern ultimately results in slow response time as application load increases. The problem is hard to detect under low