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