Database Optimization

A database can be optimized by various means:

• Creating indexes

• Putting in memory

• Using SSD (Solid-State Drive)

Alternatively processes can run in the background to avoid timeouts.