Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By pvvsksraju on
Hi,
We are observing that our site is running slow because of taxonomy_node_get_terms, there are some couple of modules that are calling the function taxonomy_node_get_terms every time when the pages load. Is there any way to tune the performance of site.
The following are the modules installed.
taxonomy_access.module
i18ntaxonomy.module
views_taxonomy.inc
taxonomy_theme_taxonomy.inc
taxonomy.inc
taxonomy_menu.module
taxonomy.module
event.module
image_gallery.module
forum.module
tagadelic.module
taxonomy_context.module
taxonomy_context.module
Thanks for your help
Srikanth
Comments
When checking the
When checking the implementation of this function, you will see that there is only one SQL statement, see below:
'SELECT t.* FROM {term_node} r INNER JOIN {term_data} t ON r.tid = t.tid INNER JOIN {vocabulary} v ON t.vid = v.vid WHERE r.vid = %d ORDER BY v.weight, t.weight, t.name'
So, you might need to check the index of the table term_node, term_data, vocabulary to see how to improve the performance.
=============================================
Want to setup a Drupal site, find the best Drupal Hosting for it now.