Domanda di colloquio di Jubilee Insurance

How would you scale a database or optimize querries?

Risposta di colloquio

Anonimo

27 set 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