Microsoft Interview Question

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

Interview Answer

Anonymous

Mar 14, 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.