Database Archives

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…

[Mysql 8] Optimizing Snapshot Management Queries in TypeORM

By Lê Hoàng Tâm September 5, 2024All topics, Database, Tips

When managing snapshots of items in a database, ensuring that only a limited number of recent snapshots are retained while older ones are removed is crucial for maintaining system performance…

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

By Lê Hoàng Tâm April 18, 2024DatabaseDatabase, Postgresql, SQL

Imagine your PostgreSQL database as a filing cabinet. Over time, you might accumulate folders you no longer need. The DROP COLUMN command acts like a handy tool to declutter your…

Database

MySQL Indexes: Boosting Query Performance with Column Order

[Mysql 8] Optimizing Snapshot Management Queries in TypeORM

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

The secret of console in javascript

Top 10 secrets of Ruby

Understanding Threads and Processes in Ruby: Optimize Performance on Multi-Core CPUs

What is Ruby’s Global Interpreter Lock (GIL) and How to Overcome Its Limitations?