Avoid This Mistake with Bulk Insert in Node.js and MySQL
Last week, I ran into a serious performance issue while working on a bulk insert…
All topics
Architecture & Design
Database
MySQL
NodeJS
Others
Tips
All topics
Database
Gems
MySQL
Others
PostgreSQL
Ruby
Ruby on Rails
Tips
How a Simple Migration Took Down Our System for 20 Minutes — And How to Never Let That Happen Again
"ALTER TABLE looked harmless. On staging, it ran in 0.4s. In production, it locked the…
All topics
MySQL
Tips
SQL Performance Battle: GROUP BY vs. Self-Join in UPDATE Queries
Which SQL UPDATE query performs better: one using GROUP BY or a self-join? This in-depth…
All topics
Database
MySQL
Others
Tips
Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis
My current query: SELECT eod.date, SUM(eod.stable_price) AS sumStablePrice FROM item_eod eod WHERE eod.date >= CURRENT_DATE…
All topics
7 Essential Caching Strategies to Boost Backend Performance and Scalability
Discover 6 powerful caching strategies to enhance backend performance and scalability. From in-memory and distributed…
All topics
Ruby
Ruby on Rails
Avoid N+1 Queries in Rails: Best Practices for Optimized Performance
To avoid the N+1 query problem in Rails, you need to minimize database queries that…
All topics
Database
NoSQL
Understanding MongoDB .hint() Method: How It Works and Its Importance in Query Optimization
In the world of database management, optimizing queries for performance is crucial. MongoDB, a leading…
All topics
Architecture & Design
Database
MySQL
Buffer Cache Hit in MySQL: What It Is and Why It Matters
The InnoDB Buffer Pool in MySQL is essentially a cache that stores frequently accessed data…
All topics
Database
MySQL
MySQL Indexes: Boosting Query Performance with Column Order
In MySQL, the order of columns in a composite index (an index that spans multiple…