Performance tuning: make your database fast again without switching it off.
When screens freeze and reports take ages, the cause is often a handful of queries or a schema that has grown with the data and no longer copes. We find the bottlenecks and fix them while your system keeps running.
Where we start
We look for the places where your database loses time, even if the schema has grown over many years.
- Find slow queriesWe analyse which queries cost the most time and start there.
- Optimise indexesWe optimise the indexes to match the queries your application actually runs.
- Rebuild the schemaIf a schema that has grown over years no longer copes, we rebuild it step by step instead of reinventing the database.
- Suited to the technologyMySQL and MariaDB for web applications and CMS, MS-SQL Server for reporting and business intelligence, MongoDB for flexible documents and IoT data streams.
How a tuning project works
We only implement what really makes a difference.
- Analyse the current stateWe look at your database’s schema, queries, load and backup.
- Name the leversYou receive a proposal showing which measures have the biggest effect.
- Implement and checkChanges are tested before they go live, with a fallback option in case something goes wrong.
Related
Has your database become too slow?
We analyse the current state and tell you which measures really make a difference.
0173 644 22 17