SQL Performance Battle: GROUP BY vs. Self-Join in UPDATE Queries
Introduction Updating records efficiently is a crucial aspect of database optimization. A poorly optimized query…
All topics
MySQL
Tips
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
1. In-Memory Caching Description: Stores frequently accessed data in the application’s memory, which speeds up…
All topics
Database
PostgreSQL
Postgres Index Methods: Things you need to know
In PostgreSQL, different types of index methods are used to optimize query performance, especially for…
All topics
Architecture & Design
Database
PostgreSQL
How to prevent table lock when add/drop index in Postgres?
The CONCURRENTLY option in PostgreSQL is used when creating or dropping indexes to avoid locking…
All topics
Ruby
Behind the Scenes of Ruby Objects lifecycle
In Ruby, objects form the core of the language. Everything in Ruby is an object—from…
All topics
Architecture & Design
Ruby
The Hidden Power of Symbols in Ruby: When to Use Symbols Instead of Strings
In Ruby programming, most developers default to using strings for everything from data manipulation to…
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…