Tag

index structure

0 views collected around this technical thread.

macrozheng
macrozheng
Mar 25, 2025 · Databases

Why Auto‑Increment Beats UUID in MySQL: Performance & Index Insights

This article investigates MySQL’s recommendation against UUIDs, comparing auto‑increment, UUID, and random snowflake keys through insertion speed tests and index structure analysis, revealing why auto‑increment keys outperform others, while also discussing the drawbacks of each approach.

Database DesignMySQLUUID
0 likes · 10 min read
Why Auto‑Increment Beats UUID in MySQL: Performance & Index Insights
Top Architect
Top Architect
Jan 15, 2025 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates why MySQL recommends auto_increment primary keys over UUID or random Snowflake IDs by creating three tables with different key strategies, running Spring‑Boot/JdbcTemplate performance tests, analyzing insertion speed, index structures, and the trade‑offs of each approach.

MySQLUUIDauto-increment
0 likes · 12 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Tencent Cloud Developer
Tencent Cloud Developer
Jan 5, 2022 · Fundamentals

Understanding Skip Lists: Principles, Implementation in Go, and Redis Integration

The article explains skip list fundamentals, shows how probabilistic multi‑level indexing yields O(log n) search and O(n) space, provides a complete Go implementation with insertion, deletion and search functions, compares Redis’s enhanced skip list used in sorted sets, and answers common design questions.

AlgorithmData StructureLinked List
0 likes · 17 min read
Understanding Skip Lists: Principles, Implementation in Go, and Redis Integration