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

System Optimization

6 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

Building Atlas Forecasting System: Production ML Deployment at Scale (Part 2)

October 3, 2025 📝 Blog

Deep dive into deploying a production ML forecasting system processing 542,000 rows/second with real-time regime detecti...

topic:machine-learningtopic:trading-financetopic:system-optimizationlang:python

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

Prioritizing Processes on Your Mac: Boosting Performance Through Smart Management

July 26, 2024 📝 Blog

Learn how to optimize your Mac's performance through strategic process prioritization, including practical techniques wi...

topic:system-optimizationtype:tutoriallevel:beginner