DatabasesWhy Your SQL Query Is Slow: Six Causes, In Order
"The database is slow" is the least useful sentence in backend work. The database is almost never slow — a specific query is, for one of about six reasons.
Read MoreThoughts, tutorials and notes on backend engineering & the cloud.
4 articles in Databases · Clear filters
Databases"The database is slow" is the least useful sentence in backend work. The database is almost never slow — a specific query is, for one of about six reasons.
Read More
DatabasesA page loaded in 200ms for a year, then took nine seconds. Nothing was deployed. The table had simply crossed four million rows.
Read More
DatabasesPostgres, MongoDB, Redis, Elasticsearch, RabbitMQ and Pinecone — for a six-person team with 4GB of data. Nobody made a bad decision individually.
Read More
DatabasesThey chose MongoDB because their data was flexible. Eighteen months on they were doing three-collection lookups per request and repairing orphans every night.
Read More