Reduce / optimize calling of wp_get_object_terms() when generating permalinks

As you had narrowed it down, since your post permalinks include category WP is trying to figure out how to put them together for every post.

Object Cache

The staple approach would be to optimize efficiency of overall setup, rather than micromanage generations of bits and pieces. If you set up persistent Object Cache for the site, then category information would be transparently cached in memory, rather than retrieved from database every time.

Shortlinks

If that is not an option or you are generating links at a scale that even gives object caching an issue there is a slightly hacky alternative. While you have “pretty” links enabled it doesn’t mean that “not pretty” links stopped working.

You can use wp_get_shortlink() function to generate latter kind of links (/?p=id), which would be much lighter on resources.

They won’t look nice in source, but when visited WP will redirect them to “pretty” versions transparently. Of course excessive redirects aren’t a good thing either, but it’s up to you if the trade-off is meaningful for your circumstances.

Related Posts:

  1. Why does WordPress combine a term with the same name in the wp_terms table?
  2. Correct use of get_the_terms()
  3. wp_list_categories: order by term order?
  4. I have a term_taxonomy_id — is there an API call to get the taxonomy?
  5. Exclude Child Terms From Parent Posts
  6. same taxonomy for several post types: how to hide empty in a specific post type?
  7. How to sort terms with diacritical signs?
  8. get_terms(); show private posts when logged in
  9. Get category ID after wp_insert_term
  10. How to order get_term_children output by alphabetic order
  11. How to update incorrect post count in taxonomy?
  12. Term begins with a letter
  13. get_post_terms not working as expected
  14. wp_update_term not creating new unique slug
  15. Wp set post terms not work
  16. How to Get All Taxonomies AND All Terms For Each Taxonomy With Post Count Zero
  17. Get post terms for multiple posts at once?
  18. wp_update_term: How could i update the “name”?
  19. Get the Term List – Ordering
  20. Check if an array of posts has posts from a specific category
  21. Get only one product category woocommerce
  22. Get those terms with a specific meta key value
  23. get_terms() order by term_meta
  24. What is the term shortlink structure?
  25. get_term_by “name” not working with & in name
  26. Invalid argument supplied for foreach() in search.php
  27. How do I determine if a certain term is in an array?
  28. Modify automatically generation of slug when term is created
  29. get_terms ‘number’ parameter does not appear to work
  30. Does get_terms() use any sort of caching on its query?
  31. Question with get_the_term_list
  32. 404 on term taxonomy archive pagination only with some terms
  33. Clone Terms of one taxonomy to another
  34. Create / Close Div in Array [closed]
  35. Categories order with get_terms_args not working in 4.7
  36. import_id parameter for wp_insert_term to create custom ID for category
  37. Why does wp_get_object_terms add a period after terms are output?
  38. How to apply comma separation,strip_tags and orderby to wp_get_object_terms
  39. How to get a post’s associated taxonomies and terms in wp api v2
  40. wp_set_object_terms not working inside loop
  41. Leveled – Terms foreach
  42. Add Taxonomy Description with wp_set_post_terms
  43. get_the_terms() not returning expected result
  44. wp_insert_post() does not support variable
  45. Missing term_id value
  46. Get the ID of category page with or without any posts
  47. single_term_title() running before get_the_title() [closed]
  48. WordPress Term for Custom List
  49. How do I print a term list but alter the link text?
  50. How to get the $meta_type given the $object_id
  51. Polylang : Display term archive even if no posts
  52. $args for get_terms() to return ORDER BY FIELDS
  53. How to create a array that contains all of the children slugs of a specific parent category
  54. Temporarily un-associate term for an amount of time
  55. How to extract one field from wp_get_post_terms objects?
  56. CTP – check for value inside objects
  57. If product is in sub-category show code
  58. Get Custom Post Child Term
  59. Get fuzzy matches from get_term_by
  60. Problem retriving the post type category
  61. Taxonomy Drop Down with hierarchical view using $terms
  62. How to check if a term is parent to another?
  63. get_terms_args ordering by meta key not working
  64. Cannot retrieve categories for post in The Loop
  65. How to show posts from category A on category B page?
  66. How to use category slug to echo a page’s content with the same slug
  67. Can we apply hide empty to get_the_terms?
  68. PHP Warning: Attempt to read property “slug” on bool in tax query
  69. wp_set_object_terms doesn’t work
  70. Why does term get inserted twice when using dynamic slug?
  71. How to use get_terms() returning only the terms that have posts with a certain custom field value
  72. how to show all categories by get_terms
  73. How to display taxonomy order child, parent
  74. Update term_id to new value wherever it exists, to combine the two.
  75. wp_get_post_terms – Do Not list Duplicates
  76. Flush rewrite rules after a term is edited
  77. How to show term child only if has a post
  78. wp_set_post_terms struggle :(
  79. How to show only tagged CPT categories / taxonomies for a custom post type?
  80. Is there any WordPress way to get all categories for some selected posts?
  81. Order terms by creation date
  82. Unable to retrieve any child terms using get_terms
  83. Wrap custom terms loop
  84. Get terms parent ID for conditional IF statement
  85. Get count for all terms inside a parent term
  86. get_terms not working when child_of is used
  87. add links to list of post terms
  88. modify strip_tags function to use term slug instead of term name
  89. When I Use function wp_insert_term() function it gives me Invalid taxonomy object
  90. get_terms Parent Tags
  91. Get term_taxonomy_id from return of wp_insert_post
  92. Get object terms with no children?
  93. How do I assign a custom post to all terms in a custom taxonomy?
  94. Attempting to filter posts using get_terms
  95. is action hook not working on quick edit?
  96. WordPress emails error regarding the argument type even if the type is correct
  97. How to solve/debug get_terms suddenly showing no results?
  98. How to get tags only with custom meta field and display them randomly?
  99. How to display First level child terms of current term’s parent taxonomy?
  100. Woo – Change order status by category [closed]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)