Optimizing function that automatically creates internal links based on post title string

  1. Use a cache plugin (or write your own custom cache plugin) to server those posts.
  2. Set the cache plugin to update posts’ contents whenever any other post title is updated / added. Or you can do this in a background process using cron.

This way your original content remains intact, but you still get quick response from the server.

Related Posts:

  1. How to solve slow WordPress site caused by attachment_metadata
  2. Database slowdown after update to 3.4.1
  3. Multiple wp_options tables to share content across installs
  4. Improve performance by removing unnecessary database queries
  5. fastest replacement DB
  6. Optimising amount of calls to custom fields
  7. Get error messages when $wpdb->insert() returns false?
  8. Detecting errors generated by $wpdb->get_results()
  9. Does dbDelta delete columns as well?
  10. How to fetch Data in WordPress using MySQLi or $wpdb
  11. WordPress database scalability from the code perspective
  12. WordPress Unit Testing – Cannot Create Tables
  13. How to define composite keys with dbDelta()
  14. Does wpdb add considerable overhead on queries with large result sets?
  15. Why does $wpdb return strings for mysql integer values?
  16. $wpdb->prepare() warning in WordPress 3.5
  17. Inserting data into custom tables
  18. Hook into $wpdb
  19. Display data from a non wordpress database on a page template
  20. Performance tips for a large user base [closed]
  21. Inserting Post Meta From SQL
  22. Improve or optimize a very slow query
  23. Why does dbDelta() not catch MysqlErrors?
  24. Connecting to external oracle database
  25. Can’t save ajax value to database
  26. What causes the “max_user_connections” warning on WordPress frontend?
  27. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  28. Updating all rows of table with $wpdb
  29. Relationship between performance and database size
  30. Is $wpdb->prepare escaping to much? How to use it properly?
  31. Remove database entries where post_date > expiration date
  32. Get data from database using $WPDB
  33. How to use a different database to list and manage comments in the backend
  34. Getting all the users who have author privilege
  35. WP Database Table to CSV file
  36. wpdb_prepare with multiple or condition
  37. $wpdb->insert is not working
  38. In what part of the WordPress core does the users table and usermeta table get joined?
  39. Modify Database in Multi-Site wp_usermeta table
  40. Advanced SELECT query with condtional statements
  41. $wpdb doesn’t like to store arrays
  42. WordPress choose wrong database
  43. Redirecting to old domain after migration website
  44. Create table from array with prepare
  45. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  46. Does WordPress $wpdb functions wait when table is locked?
  47. How to prevent/delay MySQL connections when an object cache is used?
  48. $wpdb->insert Giving duplicates
  49. How to combine multiple wp_insert_post into one in order to gain better performance
  50. I’m not able to get access to $wpdb [duplicate]
  51. Is it important to have integers inserted using %d rather than %s?
  52. Problem in using wpdb
  53. How to fetch records from database WordPress
  54. Best practice to import user base (subscribers) from one website to another?
  55. AJAX wp-mysql running too slow
  56. Clear Terms from Taxonomy for Specific Post IDs?
  57. Connecting to a different database
  58. Query Column of Specific ID from Database Table
  59. How to delete a particular row in a database table
  60. How to create more than one new wpdb object?
  61. Update multiple rows in one query
  62. How to connect and insert data in database of wordpress?
  63. Get results from wordpress data custom table
  64. Should I use an additional column in the DB?
  65. access JSON results from wordpress database with wpdb
  66. Getting value from database table depending on field value
  67. add_post_meta — not working
  68. Select From wpdb – Author/User Directory page
  69. wpdb->insert not inserting first variable
  70. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  71. $wpdb->insert not inserting all rows
  72. Is there anyway to split posts to different databases?
  73. wpdb Insert unknown post data dynamic foreach loop
  74. How do I get database rows from a custom table using wpdb?
  75. Insert NULL value using prepare()
  76. Help with $wpdb on custom code
  77. “BS_” rows in postmeta table
  78. $wpdb->insert duplicating rows
  79. How to rerieve comments and their replies from DB
  80. Best way to store 1 billion+ posts?
  81. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  82. Optimize WP site for millions of posts
  83. Help posting values to DB on submit using $wpdb->query
  84. WordPress Database Query works in phpMyAdmin but not in the code
  85. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  86. Performance bug – slow DB query
  87. Using $wpdb to insert data into a table
  88. How To connect to the same WordPress database with different database user
  89. Accessing content from third party as native posts in WordPress
  90. Call to a member function insert()
  91. I have include wp-config, should I add global $wpdb also?
  92. Processing a lot of $wpdb isn’t insert all the data
  93. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  94. Pulling values from a sepcific row in table
  95. Creating Tables in WordPress Database
  96. Inserting into data into external DB using WPDB
  97. Insert Extra fields added in the front end registration form to DB
  98. How to use remote db tables in current config? [duplicate]
  99. $wpdb->insert not working for last select option
  100. $wpdb->prepare returns empty array