THE MISSING TIER FOR QUERY COMPILERS

Summary from the TLDR newsletter

These days, a cheap NVME SSD can supply data much faster than a query interpreter can process it. Depending on the query, removing the interpreter bottleneck can yield several orders of magnitude speedup. The article looks at different options for compiling queries and their pros and cons. Queries might only be run once, so it's only worth spending time on optimization at compile-time if doing so will save even more time at runtime.