How to Diagnose and Fix Slow SQL Queries and Slow API Calls – Interview Guide

This article provides a systematic, step‑by‑step approach for identifying the root causes of slow SQL statements and sluggish API responses, covering monitoring, query analysis, index tuning, N+1 detection, caching, async processing, and architectural best practices.

API latencyCachingIndex Optimization

0 likes · 24 min read

How to Diagnose and Fix Slow SQL Queries and Slow API Calls – Interview Guide

Su San Talks Tech

Oct 20, 2025 · Backend Development

6 Proven Ways to Accurately Measure API Latency in Java Applications

This article explains why measuring API response time is crucial for performance optimization, monitoring, and user experience, and presents six practical methods—from simple System.currentTimeMillis() calls to Spring AOP, interceptors, filters, and production‑grade Micrometer/APM tools—complete with code examples, pros, cons, and suitable scenarios.

API latencyAPMInterceptor

0 likes · 23 min read

6 Proven Ways to Accurately Measure API Latency in Java Applications

Efficient Ops

May 18, 2025 · Operations

Mastering API Latency: What P90, P95, P99 and SLA Really Mean

This article explains key performance metrics such as API latency, SLA commitments, and percentile indicators P90, P95, and P99, illustrating how to calculate and interpret these values along with average and maximum latency to improve system reliability and user experience.

API latencySLApercentiles

0 likes · 5 min read

Mastering API Latency: What P90, P95, P99 and SLA Really Mean