Investigating Performance Bottlenecks With SQL & Statistics
We investigate performance bottlenecks using our own product and Google Sheets. Dogfooding reveals problems customers never report.
Read the full articleYou might also wanna read
SQL Performance Optimization: Methods for Identifying Slow Queries
This post covers tips and tricks for performance tweaking your SQL queries by first identifying which queries need work.
ohdear.app·9mo ago
Data-Oriented Optimization: Why Data Quality Matters More Than Algorithmic Tweaks for Performance
Written by David Miličević on November 23, 2025
bitsdraumar.is·7mo ago
Analyzing PostgreSQL Database Workloads: Read-Heavy vs Write-Heavy Patterns and Optimization Strategies
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
SQLite for Production: When and How to Use It Beyond Prototyping
Practical guide to running SQLite in production: performance, limits, tuning (WAL/PRAGMA), replication tools and migration signs.
Python Performance Benchmarks: Essential Metrics for Developers
A cheat sheet of real-world timing and memory numbers to guide performance-sensitive decisions.
mkennedy.codes·6mo ago
Optimizing Database Performance with Linux io_uring: Research on Effective Implementation Strategies
We study how modern database systems can leverage the Linux io_uring interface for efficient, low-overhead I/O. io_uring is an asynchronous
arxiv.org·6mo ago
Comments
Sign in to join the conversation.
No comments yet. Be the first.