🐛 | Drupal core | Improve performance of queries fetching latest node revisions by optimizing self-join logic in Entity\Query\Sql\Query::prepare()
🇬🇧United Kingdom freightdev
I encountered this on Drupal 10.3, with one node in particular having around 7000 revisions. My work around was to install Node Revision Delete module and remove all but the latest revisions. This has worked well, but the module is in RC1, so that's not totally ideal.