Put in order · NestJS course · Module 8: Caching and Performance
Database Optimization Stages
Arrange techniques from simplest to most complex DB optimization:
Items to put in order
- Use select instead of SELECT *
- Add indexes on the most frequently searched columns
- Implement pagination and lazy loading
- Consider read replicas and sharding
You can check the correct answer by solving this task in the CodeWorlds game.