#performance

4 posts · all posts

Related: benchmarksaidevelopment-processcachingtrinocorrectnessicebergstreaming
· Jacob Verhoeks

How Agentic AI Helped Us Beat Trino

221 queries, 7 suites, one week — how an AI assistant running automated benchmarks drove a major performance breakthrough.

aiperformancebenchmarksdevelopment-process
· Jacob Verhoeks

Five Layers of Caching and an 8.8x Speedup Over Trino

How multi-layer caching took SQE from slower than Trino to 2.5-8.8x faster across every benchmark suite.

performancecachingtrinobenchmarks
· Jacob Verhoeks

Streaming Writes, Sort Order Safety, and the IN (Subquery) Workaround

Fixing OOM in CTAS, safe Iceberg sort order for mixed writers, and working around DataFusion limitations.

performancecorrectnessicebergstreaming
· Jacob Verhoeks

Building a Comprehensive SQL Benchmark Suite

Seven benchmark suites, 222 queries, and the infrastructure to measure performance honestly.

benchmarkstpchtpcdsperformance