Abhishek Singh logoAbhishek Singh
JourneyWorkBlogContact
Book a call
Abhishek Singh logoAbhishek Singh

Full stack and AI solutions engineer. I build software and automation that make businesses run faster, and write about the engineering behind it.

Explore
HomeJourneyWorkBlogContact
Writing
AI DevelopmentBackend EngineeringAI-Assisted DevelopmentAll posts
Get in touch

Have a project or a problem worth solving? Tell me what is slowing your business down and I will tell you honestly how I would fix it.

Contact me→
© 2026 Abhishek Singh. All rights reserved.
Available for new projects
The blog

Thoughts on building software

Long form thinking on architecture, debugging, AI in production, and the messy intersection of code and business. The trade-offs, failures, and decisions that do not fit into tutorials.

31
ARTICLES
11
TOPICS
Weekly
NEW POSTS
Stay in the loop

New posts, straight to your inbox

One email when something new goes up. No spam, unsubscribe anytime.

Showing 1 of 1 article
A Single Missing Database Index Took Our App from 120ms to 4.8s. Here’s How I Found It
Database Engineering · 12 min read
7 months ago

A Single Missing Database Index Took Our App from 120ms to 4.8s. Here’s How I Found It

This database performance issue didn’t look like a typical failure. There were no crashes, no alerts, and no obvious slow query warnings. Locally, everything felt fast, masking the missing database index that only impacted production. As traffic increased, query performance degraded, leading to rising latency and unpredictable response times. This is exactly how hidden indexing issues silently turn into major production bottlenecks.

backend scalabilitysqldatabase optimization+4 more
Read