✅ optimize performance Archives

The Hidden Power of Symbols in Ruby: When to Use Symbols Instead of Strings

By Lê Hoàng Tâm October 15, 2024All topics, Architecture & Design, Rubycompare, optimize performance, ruby

In Ruby programming, most developers default to using strings for everything from data manipulation to hash keys. However, there's another option that is often overlooked but can be very helpful…

Buffer Cache Hit in MySQL: What It Is and Why It Matters

By Lê Hoàng Tâm September 12, 2024All topics, Architecture & Design, Database, MySQLmysql, optimize database, optimize performance, Optimize Queries, optimize query

The InnoDB Buffer Pool in MySQL is essentially a cache that stores frequently accessed data (like table rows and index pages) in memory. This reduces the need for disk I/O…

MySQL Indexes: Boosting Query Performance with Column Order

By Lê Hoàng Tâm September 12, 2024All topics, Database, MySQLDatabase, mysql, optimize database, optimize index, optimize performance, optimize query

In MySQL, the order of columns in a composite index (an index that spans multiple columns) matters. The index is optimized based on the order of the columns, and this…

optimize performance

The Hidden Power of Symbols in Ruby: When to Use Symbols Instead of Strings

Buffer Cache Hit in MySQL: What It Is and Why It Matters

MySQL Indexes: Boosting Query Performance with Column Order

Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis

AWS Backup: Simplify Your Cloud Data Protection

10 Advanced JavaScript Tricks Every Developer Should Master

Step-by-Step Guide: Setting Up Git and Shell Aliases on All Operating Systems