Philippe Gaultier • 6/12/2026

Don't run SQL migrations in tests: How I sped up the test suite by 2x

This article discusses a performance optimization technique for test suites that use SQL databases. The author explains how applying thousands of SQL migrations serially at the start of each test is a major bottleneck. By replacing migration execution with copying a pre-migrated 'golden' database file, the test suite achieved a 7x speed-up in initial tests and a 2x overall improvement. The article covers implementation details, edge cases, and alternatives, focusing on Go programming and database testing best practices.

0 comments

#sql #go #Migrations