Why
Server caches query plan by md5 hash of query text. Repeat execution skips parse. Bound values sent as bytes, not text.
Advertisement
Client caching
Driver caches prepared statement object. Reuse across queries. Prepare once at startup, use forever.
Advertisement
Anti-pattern
Preparing same query millions of times. Cache miss on driver → new prepare each time. Watch driver-side cache config.