Posts about performance

3 posts

  1. Database connection pooling: what it is and how to size it

    Why opening a database connection per request hurts, how a connection pool fixes it, and how to choose pool sizes that do not overload your database.

    3 min read

  2. HTTP caching basics: Cache-Control and ETags

    How browsers and proxies decide when to reuse a response, and how Cache-Control and ETags let your API skip work it has already done.

    3 min read

  3. Database indexes, explained without the magic

    Indexes fix slow queries but can slow down writes. What they actually do, and how to decide when one is worth it.

    2 min read