\Drupal\Core\Entity\Query\Sql\Tables causes extremely poor performance when using MariaDB and filtering on multiple relationships in JSON:API

?filter[status][value]=1 &filter[node--location][condition][path]=field_location.uuid &filter[node--location][condition][value][]=1c28abaa-f088-404f-925f-263838332601 &filter[node--location][condition][operator]=IN &filter[taxonomy_term--audience][condition][path]=field_event_audience.uuid &filter[taxonomy_term--audience][condition][value][]=9422db2a-0071-4d3e-8b33-f3762c26fc19 &filter[taxonomy_term--audience][condition][operator]=IN &filter[taxonomy_term--audience][condition][memberOf]=audience &filter[audience][group][conjunction]=OR &filter[parent][condition][path]=field_event_audience.parent.uuid &filter[parent][condition][value][]=9422db2a-0071-4d3e-8b33-f3762c26fc19 &filter[parent][condition][operator]=IN &filter[parent][condition][memberOf]=audience

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

First commit to issue fork.
Comment 11 months ago →
🇨🇿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).
Comment 5 months ago →
🇺🇸United States attheshow
It looks like the patch in #69 is no longer applying for Drupal 10.3.
Comment 5 months ago →
🇨🇾Cyprus EliasPapa
I also get an issue with applying the patch after updating to 10.3. Any updated patches available?
Comment 5 months ago →
🇨🇾Cyprus EliasPapa
After carefully investigating the changes made to the file with the updates it would seem that the patch has been added into it so there is seemingly no need for it anymore.
Comment 4 months ago →
🇺🇸United States attheshow
@EliasPapa Where are you seeing that the issue has been addressed? We're not seeing that anywhere in the code for 10.3.
Comment 4 months ago →
🇺🇸United States attheshow
This is a re-roll of patch #69 for Drupal 10.3.