Comprehensive tutorial on setting up Redis in-memory object caching for WordPress to drop SQL query counts from 120 down to under 10 queries per page.
Why WordPress Sites Suffer from Database Overhead
A standard dynamic WordPress page executes between 80 and 250 SQL queries for every visitor load. Redis Object Caching stores the results of these complex database queries in fast RAM memory, serving recurring lookups in sub-milliseconds.