📌 | Drupal core | \Drupal\Core\Entity\Query\Sql\Tables causes extremely poor performance when using MariaDB and filtering on multiple relationships in JSON:API
🇨🇿Czech Republic marysmech
#59
📌
\Drupal\Core\Entity\Query\Sql\Tables causes extremely poor performance when using MariaDB and filtering on multiple relationships in JSON:API
Active
seems to fix the problem. I use optimizer_search_depth = 0 and queries take only few ms (previously timeouted after 30s).
📌 | Drupal core | \Drupal\Core\Entity\Query\Sql\Tables causes extremely poor performance when using MariaDB and filtering on multiple relationships in JSON:API
🇨🇿Czech Republic marysmech
marysmech → made their first commit to this issue’s fork.
🇨🇿Czech Republic marysmech
I have tested latest patch and it works perfectly.