Performance Optimization Skill

Goal

To ensure systems behave predictably under load and utilize resources efficiently.

Capabilities

1. Caching Strategy

• Cache-Aside: App reads DB, populates cache. (Best for read-heavy).
• Write-Through: App writes to Cache + DB. (Data consistency).
• Edge Caching: CDN for static assets (Images, JS).

2. Database Scaling

• Read Replicas: Offload SELECT queries to secondary nodes.
• Sharding: Horizontal partitioning by Key (User ID, Region).
• Indexing: The #1 fix for slow queries.

3. Async Architectures

• Message Queues: Decouple heavy work (Sending Emails) from request loop.
• Event-Driven: Services react to changes instead of polling.