Get the latest tech news
Why SQLite Performance Tuning Made Bencher 1200x Faster
Learn why Bencher benchmarked, profiled, and tuned its SQLite database to enable better continuous benchmarking.
I believe the main reason that so many folks have had to reinvent the benchmark tracking wheel is that the existing off-the-shelf tools don’t handle the high dimensionality required. This lead to me hitting the , repeatedly overflowing the stack, suffering through insane (much longer than 38 seconds) compile times, and finally dead ending at SQLite’s max number of terms in a compound select statement. I believe the reason has to do with the fact that the Perf query is originating from the metric table and because that relationship is 0/1 or put another way, nullable it has to be scanned (O(n)) and cannot be searched (O(log(n))).
Or read this on Hacker News