Bypassing Drupal core Node Access table joins to avoid outage caused by slow queries
A client site was facing intermittent outages, specially at peak hours.
We investigated the issue over a few days, and narrowed down the cause to certain slow queries, described in more details below.
They had tagadelic on every page, displaying a tag cloud, and from that, crawlers hit every term to paths like taxonomy/term/1581.
Most Comments