SELECT component_id FROM {project_dependency_component} WHERE release_nid=:nid AND name=:name is one of Drupal.org’s most time-consuming queries now that dependencies are shown on release pages. With a static cache, the number of times this query runs can be reduced.

CommentFileSizeAuthor
#2 2825765.diff2.19 KBdrumm
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

drumm created an issue. See original summary.

drumm’s picture

Status: Active » Needs review
FileSize
2.19 KB

This adds that static cache. For https://www.drupal.org/project/og/releases/7.x-2.9, this reduces the query from running 57 times to 26.

  • trobey committed b914ecc on 7.x-2.x authored by drumm
    Issue #2825765 by drumm: Remove duplicate queries in...
trobey’s picture

Status: Needs review » Fixed

This has been committed and a new release created.

Status: Fixed » Closed (fixed)

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