Database operations

So far we have seen various code-level optimizations related to CPU and memory that we can perform to improve an application’s performance. However, the overall performance of the application is dependent on various factors such as database, IO, and network.

In the SaaS world, almost every application out there is database dependent. This means, we need to focus on various aspects related to database optimization. Several performance issues are the result of poor architectural decisions, the wrong use of design patterns, improper database configurations, and sometimes incorrect database type selection. In this section, we will focus on identifying various database-related bottlenecks and briefly discuss the areas of improvements. Database optimization itself is a vast topic and out of the scope of this section. In order to optimize the database you need to look at various different aspects such as cache management, JDBC batching, connection pool management, indexing, query...