How would you scale a database or optimize querries?
Utilisateur anonyme
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