advagg_get_files_from_hashes() function queries the database to get all the files that belong to the aggregate. Unfortunately this query regularly shows up in slow query log. Fixing this query seems like a no-brainer. I will upload a patch soon.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

neeravbm’s picture

neeravbm’s picture

Status: Patch (to be ported) » Needs review

  • mikeytown2 committed 551f78c on 7.x-2.x authored by neeravbm
    Issue #2294477 by neeravbm, mikeytown2: Optimize MySQL query to get...
mikeytown2’s picture

Status: Needs review » Fixed
FileSize
2.38 KB

Thanks! I committed a slightly modified version of your patch.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.