Performance in a High-throughput SQL Database

Explore performance optimization techniques for high-throughput SQL databases in this 45-minute conference talk from GopherCon 2022. Learn how to profile your Go codebase to enhance speed and efficiency, while discovering common performance-killing anti-patterns to avoid. Follow along as Zach Musgrave, from the DoltHub team, shares insights gained from developing Dolt, a unique SQL database with Git-like versioning capabilities. Gain practical knowledge on utilizing Go's profiler tools to identify and resolve code slowdowns, illustrated through real-world examples from DoltHub's codebase. Delve into the architectural decisions behind Dolt's tuple storage system and understand their impact on overall database performance. By the end of this talk, acquire valuable strategies to optimize your own Go-based database projects for improved throughput and responsiveness.