WP Options Query “Rewrite Rules” Taking 10 Seconds After Testing wp_insert_post( )

The solution was to change the permalink structure from

/%postname%/%post_id%

to: 

/%post_id%/%postname%/

This magically fixed it – possibly WordPress queries are not so efficient the other way around or I ran into a bug with a plugin. Anyway, it’s blazing fast again, both backend and frontend

Related Posts:

  1. Are transients garbage collected?
  2. Are all options loaded to memory on each request?
  3. How to pass variable to add_settings_section() callback?
  4. Using widget options ‘outside’ the widget
  5. How to load WordPress on non WP page?
  6. Difference between Option_Group and Option_Name in Register_Settings
  7. Why does WordPress use serialize rather than json_encode for the options table? [duplicate]
  8. Plugin options will not save in database
  9. How to Create a Custom WordPress Install Package?
  10. Settings API – creating reusable form elements?
  11. Efficient way of saving plugin options
  12. register_setting() vs add_option()
  13. Where to hook register_settings for Settings API when also want to update options outside of Settings API?
  14. How much string content can I store in an option?
  15. Why isn’t get_option array contents displaying?
  16. How to Save Different Settings Options Using Settings API and/or the Theme Optimizer
  17. Define WordPress image size in img tag
  18. get_option() is not working even db contains the corresponding option_name and option_value
  19. Proper use of option_page_capability_{$page_name}
  20. Which WordPress option stores the current active theme?
  21. update_option method with support of utf8
  22. Can I use a space in an option name/key?
  23. How to save WordPress Options as an array?
  24. update_option not working in stand-alone PHP script
  25. How to verify this checkbox is checked?
  26. What to use , set_transient, set_option or file system? [closed]
  27. Settings API get_option best practices
  28. Custom theme options Radio inputs not saving
  29. Deploy pre-configured database
  30. Tab from Settings API resetting all options with INSERT INTO [closed]
  31. display all posts in wordpress admin crashing after 999 screen option
  32. Allow spiders to crawl my site (selectable option in wp)
  33. Putting my site live
  34. get_option array value defaults and best practices
  35. Add an option to a Child theme of Twenty Eleven
  36. The Settings API – What is the purpose of default value in register_setting?
  37. WordPress options page not saving
  38. How to store a value on WP_option table
  39. Changing the language in Site Language does nothing
  40. Two settings_fields in one form
  41. Custom blog settings
  42. wp_usermeta wp_usersettings
  43. Can’t save checkbox option
  44. How to set wp_editor to be email friendly?
  45. Work flow for multiple developers
  46. i changed my wordpress address url in SETTINGS – GENRERAL – wordpress address site url. cannot login anymore
  47. update object options on option form
  48. Functions to edit wp-config.php [duplicate]
  49. Saving plugin options page
  50. Transients API conditional
  51. How to use a newly registered setting with a checkbox and the default value ‘true’
  52. help using get_option
  53. Testing for addon plugin activated
  54. How to check False booleans when using get_option?
  55. Where have the Privacy Settings gone in WordPress 3.5?
  56. Is there any other place – besides a theme, a plugin, or a mu-plugin – that an option page might conceivably be used?
  57. How to save custom settings api fields with custom section fuction
  58. Custom options in plugin, register_settings not working as no options.php?
  59. Verify Values Using Settings API
  60. How can I increase the font sizes used by the WordPress visual and HTML post editors?
  61. Which Hook can I use when creating unique post but not update/save/delete
  62. How to use update_option() without replacing/losing the old value?
  63. how create an html table with all values from a serialized array in option_value
  64. Settings API and ‘type’ => ‘font’
  65. Create a counter variable in wp_options that increments when submit button is pressed
  66. Assigning a Setting to a Variable and Using it in an if Statement
  67. Options page: values don’t show up in dashboard
  68. WordPress Settings API settings not saving for some users
  69. Sharing Buttons not Working – Sharing Settings [closed]
  70. Character \ appearing before ‘ after saving a settings page
  71. Theme Option select values
  72. How to add a Reset to Defaults button with Settings API?
  73. Settings API no update status? (refering to the yellow bar when you save settings)
  74. PHP class to add pages and fields in admin panel
  75. get_option() and update_option() in a transaction (for an autoincrement value)
  76. How to change color of a word in text after WP update
  77. display category name based on its equivalent id
  78. Option value not get saved in the database
  79. Is it possible to have a global parameter page which allows to configure other plugins in the same place?
  80. Help to create the best plugin settings!
  81. Encoding matter – ? instead of € after settings field callback
  82. Problem with checkbox in Settings API
  83. add image in dropdown select
  84. Access saved Options / Settings
  85. Repeatable option fields not saving
  86. Settings API retrieving options database information alongside with user information?
  87. Dynamically Update Key in Associative Array When Saving Settings
  88. Incorporating the Settings API in WordPress Themes – by Chip Bennet
  89. Option does not save or update upon page refresh
  90. WordPress options text format
  91. Caching of SQL queries
  92. WordPress theme options tabs
  93. Importing WP settings to another host
  94. Only show theme option if it option exists
  95. The issue of redirecting my site to a new domain
  96. Custom general settings (textarea field) don’t output HTML correctly
  97. Using get_option() for check box field
  98. Where to adjust presets for slider options “auto rotate” (3, 5, 10, 15 seconds)? [closed]
  99. change backend header options
  100. If Home Page Do Nothing, If All Else Show This Content