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

Comments

Popular posts from this blog

Check MySQL query history from command line

Fixed: ImportError: No module named utilities.common.tools