5 articles
Six database optimization techniques — predicate pushdown, row group pruning, result caching, async I/O, indexes, and where SIMD goes wrong — with impact numbers and code.
I replaced DuckDB with a custom Rust query engine for a trading-system time-series workload. Five iterations, 10.4× speedup, one optimization that backfired.
How the Atlas forecasting system handles 542,000 rows/second of market data with sub-second regime detection — async service architecture, dependency-ordered startup, and 10Hz health monitoring.
Atlas couldn't start. The trading system's database initialization was taking 6.6 seconds, blocking 37 features from loading. The fix was small.
A working reference for production database tuning — SQLite PRAGMAs, schema, indexing, transactions, batching, pooling, and the monitoring that proves it's working.