Microsoft interview question

5. A database call takes 500 ms. How would you optimize it?

Interview Answer

Anonymous

14 Mar 2026

Approach: First identify the bottleneck, then optimize using caching (Redis), indexing queries, reducing unnecessary data fetch, connection pooling, and read replicas for scaling read-heavy workloads.