Nov 5, 2017

Database Performance bottleneck

When it turns out that the database is the main contributor to the overall response time of requests to your web application, there might be several reasons:

  • Inappropriate database configuration: memory, disk, tablespaces, connection pools
  • Poor design and data structure in the database: table relations, slow stored views, missing or wrong indexes, outdated table statistics
  • Inefficient use of the database: wrong query design, poor application logic, incorrect configuration of data access framework