# Database performance tuning during operation

> Find slow queries, optimise indexes, rebuild grown schemas: performance tuning for MySQL/MariaDB, MS-SQL Server and MongoDB while your systems keep running.

Source: https://1x1it.de/en/datenbankdesign/performance-tuning/

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.

[Have your database checked](https://1x1it.de/en/kontakt/#anfrage)
[All database services](https://1x1it.de/en/datenbankdesign/)

Performance tuning Service

- **Approach:** slow queries, indexes, schema
- **Operation:** also on live systems
- **Systems:** MySQL, MariaDB, MS-SQL, MongoDB
- **Process:** analysis, proposal, implementation

## Where we start

We look for the places where your database loses time, even if the schema has grown over many years.

- Find slow queries: We analyse which queries cost the most time and start there.
- Optimise indexes: We optimise the indexes to match the queries your application actually runs.
- Rebuild the schema: If a schema that has grown over years no longer copes, we rebuild it step by step instead of reinventing the database.
- Suited to the technology: MySQL 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 state: We look at your database’s schema, queries, load and backup.
- Name the levers: You receive a proposal showing which measures have the biggest effect.
- Implement and check: Changes are tested before they go live, with a fallback option in case something goes wrong.

## Related

[Migration & replication Switch systems without data loss](https://1x1it.de/en/datenbankdesign/migration-replikation/)
[Backup strategy Backups that can be restored](https://1x1it.de/en/datenbankdesign/backup-strategie/)
[Software development Web applications with a matching database](https://1x1it.de/en/softwareentwicklung/)
[Databases All services at a glance](https://1x1it.de/en/datenbankdesign/)

## Has your database become too slow?

We analyse the current state and tell you which measures really make a difference.

[0173 644 22 17](tel:+491736442217)

[Discuss a database project](https://1x1it.de/en/kontakt/#anfrage)