Database Archives

Understanding MongoDB .hint() Method: How It Works and Its Importance in Query Optimization

By Lê Hoàng Tâm October 16, 2024All topics, Database, NoSQLoptimize database

In the world of database management, optimizing queries for performance is crucial. MongoDB, a leading NoSQL database, provides various tools to ensure that queries run efficiently, one of which is…

Foreign Keys and Performance: Things You Might Not Know in RDBMS

By Lê Hoàng Tâm September 26, 2024All topics, Database, MySQL, PostgreSQL

A FOREIGN KEY in a relational database management system (RDBMS) is a constraint used to maintain referential integrity between two tables. The performance impact of using foreign keys can affect…

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

By Lê Hoàng Tâm September 25, 2024All topics, Architecture & Design, Database, PostgreSQL, Ruby on RailsDatabase, Postgresql

Introduction As your application scales and serves multiple tenants, choosing the right multi-tenancy architecture is critical. One popular approach in the Rails ecosystem is schema-based multi-tenancy, particularly with PostgreSQL. In…

Understanding PostgreSQL WAL and How It Can Save Your Data

By Lê Hoàng Tâm September 12, 2024All topics, Database, PostgreSQLDatabase, Point in time recovery, Postgresql, WAK, WAL

PostgreSQL’s Write-Ahead Logging (WAL) system is a fundamental component that ensures database durability, data integrity, and the ability to recover from crashes. If you've ever wondered how PostgreSQL can help…

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…

Database

Understanding MongoDB .hint() Method: How It Works and Its Importance in Query Optimization

Foreign Keys and Performance: Things You Might Not Know in RDBMS

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

Understanding PostgreSQL WAL and How It Can Save Your Data

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

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?