Tag feed

#database-optimization

40 posts1 followers

Explore Hashnode

Alternatives

Trending tags this week

UDUtsav Dattautsavdatta-syslog.hashnode.dev2d ago · 5 min read

Why I replaced CTEs with Temp Tables in SQL Server Stored Procedures

Recently I was working on some "SQL Performance Tuning", where I had to rewrite few stored procedures to improve their performance. While tuning stored procedures, I often found myself replacing CTEs

0

YVYashika Vijayvargiyarailswithyashika.hashnode.devJun 15 · 4 min read

PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production

In this article, we'll explore what concurrent indexes are, why they matter, and how to safely create them in Ruby on Rails. The Problem with Normal Index Creation Suppose we have a large users table

0

Bbinaditbinadit.hashnode.devApr 27 · 5 min read

How a SaaS platform cut infrastructure costs by 40% while improving response times

Breaking the performance vs cost trade-off: A SaaS infrastructure optimization case study Infrastructure optimization often feels like a zero-sum game between performance and cost. Faster systems cost more, right? A recent project with a European CRM...

0

Ssandeepbansod007stackdevlife.hashnode.devApr 17 · 3 min read

We Deployed a "Small Fix" and Took Down Production — Here's What Actually Happened

A minor backend change caused a production outage, high CPU usage, and API failures. Here's how it happened, what we missed, and how we fixed it. The Incident It started as a simple task. "Just add o

0

PPPRATIK PATELblog.pratikpatel.proMar 31 · 6 min read

Prisma N+1 in Production:Real Query Plans and Fixes

The silent killer hiding in your ORM It was a Tuesday morning when our on-call alert fired. P95 latency on /api/dashboard had crossed 4 seconds. Nothing had been deployed. No traffic spike. The databa

0

DSDavid Shustermandavidshusterman.hashnode.devMar 13 · 7 min read

Why Your WordPress Site Is Slow (It's Not What You Think)

Most developers immediately blame plugins or themes when their WordPress site crawls. While these are common culprits, the real performance killers often hide deeper in your infrastructure—and fixing them requires looking beyond the obvious suspects....

0

PPPayal Porwalcodeswithpayal.hashnode.devFeb 24 · 5 min read

Master the Top SQL Queries: Clear Explanations + Practical Examples

1️⃣ SELECT (Basic Data Fetching) 🔹 What it does: Fetch data from a table. 🔹 Syntax: SELECT column1, column2 FROM table_name; 🔹 Example: SELECT name, salary FROM employees; 🔹 Use Case: Showing u

0

ATAditya Trivediadityatrivedi.hashnode.devFeb 24 · 6 min read

The Thundering Herd Problem: Explained

Imagine you're standing outside Apple store on the release of it's new store. The doors are locked, and 1,000 people are huddled outside, all waiting for the same new IPhone 18 Pro Max. The moment tho

0

TITech Insights Hubtopperblog.hashnode.devFeb 13 · 6 min read

How to Implement Real-Time Analytics with ClickHouse

How to Implement Real-Time Analytics with ClickHouse ClickHouse has emerged as one of the most powerful open-source columnar database management systems for real-time analytics. Developed by Yandex, it's designed to handle massive volumes of data wit...

0

TITech Insights Hubtopperblog.hashnode.devFeb 13 · 7 min read

Database Indexing Strategy Guide for Query Performance

Database Indexing Strategy Guide for Query Performance B-tree, hash, and composite indexes in PostgreSQL and MySQL As applications scale beyond initial prototypes, database query performance becomes the bottleneck that keeps engineering teams awake a...

0

#database-optimization

Search Hashnode

#database-optimization

Explore Hashnode

Trending tags this week

Why I replaced CTEs with Temp Tables in SQL Server Stored Procedures

PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production

How a SaaS platform cut infrastructure costs by 40% while improving response times

We Deployed a "Small Fix" and Took Down Production — Here's What Actually Happened

Prisma N+1 in Production:Real Query Plans and Fixes

Why Your WordPress Site Is Slow (It's Not What You Think)

Master the Top SQL Queries: Clear Explanations + Practical Examples

The Thundering Herd Problem: Explained

How to Implement Real-Time Analytics with ClickHouse

Database Indexing Strategy Guide for Query Performance