Skip to main content

Databases for Backend Performances

Database performance work means making queries return quickly and keeping the database healthy as load rises. It includes reading query plans, designing indexes, avoiding N+1 patterns, pooling connections and scaling with replicas or partitioning. The database is the most common bottleneck in a backend, so this unit has the highest payoff.

Stage: Data Layer · Part of the Backend Performance roadmap · Last reviewed 19 November 2026

What to learn in Databases

Databases interview questions

Why can adding an index make writes slower?

Each index is a separate structure that must be updated on every insert, update or delete that touches its columns. More indexes mean more write work and more storage. Index the columns that real queries filter or sort on, and drop unused ones.

What is connection pooling and why is it needed?

A pool keeps a small set of open database connections that requests borrow and return. Opening a connection is costly, and databases cope badly with thousands of simultaneous ones. Pooling cuts connection setup time and caps load on the database.

Where Databases fits in the Backend Performance roadmap

Databases belongs to the Data Layer stage (advanced level), which takes about 14 hours. Usually the bottleneck.

Back to the full Backend Performance roadmap