- 🇨🇦Canada joseph.olstad
Our varnish cached and purge optimized production drupal site became unresponsive and ran out of resources for 20 minutes at a moment that co-incided with an entity_usage query that showed up in our slow query log, 22 million rows_examined by the query (not sure why so many) the slow query took over 5 minutes to execute on a persona /mysql compatible db hosted on the acquia platform.
The query originates from the entity_usage module.
- 🇨🇦Canada joseph.olstad
These two related issues won't help for bulk processing. Rather than use joins we should consider making a patch to write a replacement query that uses sub queries intead of joins.
Sub queries are much more efficient than joins.
With that said, it's maybe going to be tricky to do.
- 🇨🇦Canada joseph.olstad
These two related issues won't help for bulk processing. Rather than use joins we should consider making a patch to write a replacement query that uses sub queries intead of joins.
Sub queries are much more efficient than joins.
With that said, it's maybe going to be tricky to do.