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))).

Get the Android app

Or read this on Hacker News

Read more on:

Photo of bencher 1200x

bencher 1200x