Performance

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 ...

TL;DR: Use ergebnis/phpunit-slow-test-detector to surface your slow PHPUnit tests, then use that as a metric for parallelizing or splitting your test jobs. ergebnis/phpunit-slow-test-detector: A PHPUnit extension that detects and reports slow tests exceeding a configured threshold The “which tests are slowing down CI?” problem Your CI tests are slow. They keep getting slower, and waiting after every push gets old fast. But when you actually try to speed things up, you can see that “the whole thing takes 5 minutes” — yet “okay, but which tests are dragging it down?” doesn’t jump out at you. You might have a vague hunch that “the tests touching the DB are probably the suspects,” but you haven’t actually measured anything. ...