I'm using placeholder variables for the URL in a panel page. The Context assigned is Taxonomy term: ID. The argument type is Term Name and I've selected to transform dashes in the URL to spaces in term name filter values.

So: mywebsite.com/articles/%TermName/news validates a page for every particular term name in the selected vocabulary.

This works as it should but when I link in the menu to this creates a lot of SQL overhead. Looking at the query log I see multiple instances of DrupalDefaultEntityController::load along with 7-9 more queries for every link in the menu that links to this kind of panel page.

When I change the argument context to String, this SQL load go away. Unfortunately doing this breaks the views on those pages that rely on the term context and I can type in any string to replace that %TermName and the page still renders. I don't want that to happen.

It seems I'm on the hook to create a variant for every one of the my taxonomy terms. I really don't want to do this.

Why so many SQL calls?

Comments

museumboy created an issue.