Pregunta de entrevista de Jubilee Insurance

How would you scale a database or optimize querries?

Respuesta de la entrevista

Anónimo

27 de sept de 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