Java Dev vs Slow SQL Database

We had pleasure to welcome around 50 people to our meetup which took place in ICT Hub Belgrade.

Our colleague Ognjen talked about monitoring of database, most common reason for your database going slow and examples of bad SQL queries.

Short abstract: How to monitor a database? What are the most common causes of slowdown? Data access: index scan, bitmap index scan and sequential scan. Index creation strategies. Query analysis. Statistics collector and the consequences of incorrect statistics. Examples of bad SQL queries. Examples of inproper usage of ORM framework. Prepared statements. Efficient pagination. Processing large amounts of data. Concepts are applicable to all databases, but some of the examples are specific to PostgreSQL.

We hope that this topic was interesting and useful for you and that you will join us at our next meetup in March.