The MariaDB subquery cache feature added in MariaDB 5.3 is not widely known. Let’s see what it is and how it works.
What is a subquery cache?
The MariaDB subquery cache optimizes the execution of correlated subqueries. Correlated subqueries refer to a value from the parent query. For example:
SELECT id FROM product WHERE price NOT IN (SELECT […]Read more