database

10 ideas

Scaling

Systems can be scaled:

  • Vertically - by increasing the resources of a specific node (more CPU, memory, disk etc.). This is easier to do, but it's limited. You can only add so many CPU cores and memory.
  • Horizontally - by adding more nodes of the same kind. This usually requires adding a load balancer in front of your nodes to distribute the load evenly.

7 STASHED

Key Concepts for System Design

📖 Cracking the Coding Interview

6 IDEAS

Finding query bottlenecks

Review your API endpoints and views for:

  • Duplicate queries
  • Slow queries
  • ORM calls that resolve more queries than you expect

2 STASHED

Speed up query-heavy requests

📖 Two Scoops of Django

4 IDEAS