Database optimization: find slow queries and speed them up

The cost depends on the size and number of databases, the application behind them and the scope of the changes required. Depending on scope, an analysis with an action plan and first optimizations is possible in the Starter package from €2,500, while more extensive changes to the data model and application tend to fall under the Professional package from €8,000. You will receive the exact quote after the free initial consultation.

The most effective approach is to measure first which queries consume the most time. After that, suitable indexes, rewritten queries and a configuration adapted to the hardware often help. Only once these options are exhausted do caching, read replicas or bigger servers make sense.

An analysis with first results is often possible within a few days to a few weeks, depending on how long we need to observe normal operation. We plan larger changes to the data model or the application in stages. After the analysis, we give you a realistic schedule.

We work with MySQL, MariaDB, PostgreSQL and Microsoft SQL Server, and with Redis as a cache. Whether the database runs on your own server, with a hosting provider or as a managed cloud service makes little difference to the analysis. What matters is an access that lets us evaluate statistics and execution plans.

Sometimes in the short term, but it usually just postpones the problem. A query without a suitable index keeps getting slower as the data grows, no matter how powerful the server is. We show you which measure has the biggest effect on your database – sometimes that really is more memory.

We start with read-only measurements and test every change on a copy with realistic data. On large tables we create indexes in a way that avoids blocking operations wherever possible, and we deploy changes in agreed time windows with a backup. That keeps every step reversible.