#indexing Development Tutorials & Tips | Roast Dev

Building Jam-Text: A High-Performance Text Indexer in Go

Last month, I teamed up with some brilliant folks—Elijah, Kevin, Jerome, and Godwin—for a hackathon challenge: build a fast, scalable text indexer in Go. The goal? Create a tool that could chew th...

16.03.2025 0 Read More

The Power of MySQL Indexes: A Comprehensive Guide [MySQL part 1]

Indexes are essential tools in MySQL that significantly enhance query performance. By allowing the database to locate data without scanning every row, indexes can dramatically speed up data retrieval....

11.04.2025 0 Read More

Database Optimization: Partitioning vs Indexing

𝗣𝗮𝗿𝘁𝗶𝘁𝗶𝗼𝗻𝗶𝗻𝗴 - Horizontal partitioning divides large tables across multiple storage nodes based on region, such as East, West, and South.Vertical partitioning, on t...

12.04.2025 0 Read More

What is Database Indexing?

Indexing is a database optimization technique that creates specialized lookup structures (B-Trees).𝗜𝗻𝗱𝗲𝘅𝗶𝗻𝗴 𝗞𝗲𝘆 𝗕𝗲𝗻𝗲𝗳𝗶𝘁𝘀 → Fasts data retriev...

14.04.2025 0 Read More

Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

TL;DR Slow queries? Check your indexes first. Use EXPLAIN and the slow query log to guide indexing decisions. Composite indexes only help if you use leading columns. Covering indexes = 🔥 for per...

20.04.2025 0 Read More

🔍 How MongoDB Indexing Works Internally: B+Tree Structure, Performance Impact & Best Practices

Indexing is the backbone of database performance. In MongoDB, indexes are not just a luxury—they're essential for building scalable, performant applications. But how do they really work under the ho...

04.05.2025 0 Read More