MySQL Performance Pitfall: Querying a String Column with a Number
When working with MySQL, it’s common to have columns stored as strings (VARCHAR, CHAR, TEXT).But…
Database
MySQL
Database
MySQL
NodeJS
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…
MySQL
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…
MySQL
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…
Database
MySQL
Enhancing Text Search in MySQL: A Comparison of SOUNDEX and Full-Text Search
In many applications, efficient text search capabilities are critical for delivering fast and relevant results…
Database
MySQL
Tips
A Comprehensive Guide to Indexing in MySQL: Boost Your Database Performance
Indexes are essential tools in MySQL that drastically improve query performance, especially when dealing with…
Database
MySQL
PostgreSQL
Tips
Exploring Views in MySQL and PostgreSQL: A Guide to Performance, Use Cases, and Materialized Views
Views are a powerful feature in relational databases like MySQL and PostgreSQL, allowing you to…
Database
MySQL
PostgreSQL
The secret of Locking Behavior in Mysql and Postgres
The default locking behavior of MySQL and PostgreSQL can affect how transactions interact with one…
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…
Database
MySQL
Ruby
[Mysql 8] Optimizing Snapshot Management Queries in TypeORM
When managing snapshots of items in a database, ensuring that only a limited number of…