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.