Jubilee Insurance interview question

How would you scale a database or optimize querries?

Interview Answer

Anonymous

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