Browse Teach Curate

Network Round-Trip Latency

Every statement pays at least one client-to-server round trip — commonly 0.5–5 ms across a datacenter — before any database work happens. Chatty access patterns are therefore latency-bound: 1,000 tiny queries cost seconds in transit even if each executes in microseconds.

Questions this Concept answers

Why can an endpoint be slow when every query in the slow query log is fast?

jeremy Text

How to Implement Batch Processing for Performance

Every statement sent to a database waits for a message to travel to the server and back before any work happens, and that wait is measured in milliseconds. Do it a thousand times in a loop and the tr…