Question d’entretien chez Jubilee Insurance

How would you scale a database or optimize querries?

Réponse à la question d'entretien

Utilisateur anonyme

27 sept. 2025

add more connections to the db - MySql by default ships with 100 but this can be increased. Cache frequently used querries. Use stored procedures - they usually cache impl by default. Vertical - add more resources to the machine running the db. Horizontal - replication