Profile icon
David Burton
Data Scientist
Home
Interactive Dashboards
Data Science & ML
Engineering & Automation
Research & Writing
Back to Research

Database Performance

4 items

Database Optimization: A Practical Reference Guide

October 4, 2025 📝 Blog

Comprehensive reference for database optimization techniques, from predicate pushdown to result caching. Includes perfor...

topic:database-performancetopic:system-optimizationlang:rusttype:reference-guide

Replacing DuckDB: 10x Performance with Rust and Predicate Pushdown

October 4, 2025 📝 Blog

How a custom Rust query engine replaced DuckDB and achieved 10.4x speedup through predicate pushdown. Covers 5 optimizat...

topic:database-performancetopic:system-optimizationlang:rusttype:case-study

Optimizing Atlas Trading System: 810X Database Performance Improvement (Part 2)

October 3, 2025 📝 Blog

Deep dive into optimizing a production trading system's database initialization from 6.6 seconds to 8.2ms, unblocking 37...

topic:database-performancetopic:system-optimizationtopic:trading-financelang:python

Database Performance Optimization: A Practical Reference Guide (Part 1)

October 8, 2024 📝 Blog

Comprehensive reference for optimizing database performance in production systems, covering SQLite configuration, schema...

topic:database-performancetopic:system-optimizationlang:pythonlang:sql