Performance

Developer Tools 5 min What Your Monitoring Costs the Database Metadata queries are expensive because the server assembles the answer by walking itself. Measured on producti... KE Kenji Tanaka 23 Aug Developer Tools 5 min How to Find What Is Scanning Your Tables Knowing a table is scanned tells you little; knowing which statement scans it tells you everything. Reading My... KE Kenji Tanaka 23 Aug Developer Tools 6 min Sixty Percent of Your Reads Use No Index A database either uses an index to find rows or scans the table, and on a small table the scan is the right ch... KE Kenji Tanaka 23 Aug Developer Tools 6 min The Indexes Nobody Reads Indexes accumulate because nothing ever removes them, and removing one means proving it is unused. MySQL will... KE Kenji Tanaka 23 Aug Developer Tools 6 min Your Daily Report Is Counting the Wrong Day A naive date filter and a timezone-aware one disagreed on twelve of twenty-one days, once reporting six items... KE Kenji Tanaka 23 Aug Cloud & Infra 5 min How Far Away the Cloud Is From Singapore A dropdown asks which region, and most people pick the familiar name. Measured from a server in Singapore, the... KE Kenji Tanaka 21 Aug Cybersecurity 7 min How Big Are Post-Quantum Encryption Keys? We measured two live handshakes to our own site. Hybrid post-quantum key exchange adds 1,178 bytes to the Clie... KE Kenji Tanaka 16 Aug Consumer Tech 6 min How Much Internet Speed Do I Need? Stop Multiplying by People The usual method — one person's needs times the number of people — assumes a connection gets divided. We measu... AM Amelia Wong 11 Aug Developer Tools 6 min Latency vs Bandwidth: Which One Are You Actually Waiting For? Internet plans are sold in one number, and for most of what you do all day it is the smaller half of the answe... KE Kenji Tanaka 11 Aug Consumer Tech 8 min Why Is My Wi-Fi Slow? Usually, It Is Not the Wi-Fi A page load is five separate stages, and the radio is only involved in one of them. Timed across three real si... AM Amelia Wong 10 Aug Developer Tools 6 min How to Take a Screenshot (and Not Ruin It Afterwards) The keystroke is the easy part. What you have made is a PNG, often several megabytes, and almost every piece o... KE Kenji Tanaka 9 Aug Consumer Tech 8 min How to Clear Your Browser Cache (and When It Will Not Help) Clearing the cache is the reflex, and it is usually the wrong lever. Measured on one of our own pages: the cac... AM Amelia Wong 9 Aug Developer Tools 11 min Does Re-Saving a JPEG Make It Worse? Re-saving a JPEG is nearly lossless at exactly one quality — the one it was already saved at — and roughly for... KE Kenji Tanaka 8 Aug Developer Tools 15 min Which Image Format, and Why Your Photos Are Too Big One of our own hero photos was 198,372 bytes. It is 59,766 now — same photograph, same dimensions; we finally... KE Kenji Tanaka 1 Aug