CakePHP 5.4.3 may speed up building queries with deeply nested conditions
TL;DR: CakePHP 5.4.3 fixes a bug where compiling a query with deeply nested WHERE conditions got exponentially slower. On MySQL/MariaDB it was a regression in 5.4.0–5.4.2 (or already slow in 5.3 if you enable quoteIdentifiers); on PostgreSQL and SQLite it was already slow in 5.3. Whatever your database, if your app builds conditions by nesting them, upgrading to 5.4.3 alone may make it faster. Avoid repeated query expression visits #19637 ...