Search through custom post type and custom fields takes 5 minutes

You got a preg_match_all(), various JOINs, anonymous/lambda functions. In short: Everything that makes debugging hard and is performance wise a no-go.

In short: You should use a meta_query instead. Take a look at

Code meta_query » Multiple Custom Field Handling:

Related Posts:

  1. Creating search form for custom database table
  2. Customise search form in the Widget
  3. Comment filtering (search)
  4. Combine multiple words in custom meta search query
  5. Custom search page and search by title, content and tag
  6. Search a post using the date it was posted
  7. Setting custom search engine indexing for a “dynamic WordPress page” with htaccess
  8. Custom URL going to 404
  9. Search result page redirect ex.com/?s=searchterms to ex.com/searchterms
  10. Hi, I wanted to make custom search with multiple fields
  11. Steps for custom data retrieval
  12. Custom search to display results within same page
  13. Search widget will search everything in the site, how to limit to only search gallery name
  14. How to hook up search results page to a back-end page?
  15. Admin search post meta
  16. Add a searchbox to the body of a page
  17. Custom Search on Custom Page while preserving the main search function
  18. Custom Loop Query For Search Page
  19. Search URL parameters query [duplicate]
  20. Applying WP-cli Search & Replace to Static SQL Dump File
  21. How to create custom search page
  22. Setup database structure with books, authors, languages etc. for publishing house [closed]
  23. Custom Same Page Search
  24. How to Add Additional Search Button?
  25. How to Clear Empty Search values?
  26. WP Search Form Query: Add Author’s posts into search query
  27. WordPress search on a custom table
  28. Adding overlay search to wordpress using add action/filter
  29. Allow WP users to sort search result on a videos site
  30. WP_User_Query Search Multiple Keywords from a Multi-Select Field?
  31. How to create custom post type selection to nav menu
  32. Custom dropdown search form that allows users to select option B based from Option 1
  33. Custom search results
  34. Taxonomy template by post type
  35. WordPress custom search – pagination
  36. Creating a search with tag variable also added for more detailed results
  37. What shortcode should I use for
  38. Two searchforms with different categories/posts per page
  39. Search a meta field for a value in all posts
  40. Custom search by several options send on form not works
  41. Search results load individual post in slide out div
  42. Custom Search Results Page
  43. WordPress Search on Multiple wp sites
  44. Create a custom search for Estate Agency WordPress site
  45. How can I make a search term redirect to a page
  46. Sort Search Results in Order of/by Character @ count (9) of post(s) title. (Ocean-WP theme)
  47. Show total sales for each products on search results page Woocommerce
  48. Custom Search on media files PDF images pages posts
  49. Adding Custom Fields to WordPress Comment Forms?
  50. How to extend a class in WordPress?
  51. Create a customizable child theme
  52. Custom image size not selectable in uploader
  53. Many users with strange names register, but don’t leave comments. Should I be afraid?
  54. Default WP search excluding specific characters, is it possible?
  55. Tag description doesn’t show hyperlink
  56. Is there a way to rename “themes” directory name?
  57. Custom query with DECIMAL(5,2)
  58. How to remove tag cloud from taxonomy admin edit page?
  59. Post Thumbnail help
  60. Unable to display custom fields on WooCommerce product pages
  61. Make blog secret during design construction
  62. Admin Panel – Custom Menu Sub-Item LINK
  63. Adding custom styles to dropdown in editor
  64. Add custom user profile field to default WordPress MultiSite registration form
  65. how to add custom css and js on wordpress post editor directly without using .php file
  66. Custom attachments styling in post view
  67. window resizing problem
  68. Create membership number for existing/new users
  69. Gutenberg block outputting JSON in front end – is this normal?
  70. Cutom wp_query for geolocation search, pagination not working
  71. Custom link for wp_insert_post
  72. Hide text if not homepage
  73. Exclude posts with specific metadata from search?
  74. Lost password and back to blog in same line
  75. WordPress broken after domain name change
  76. How to Restore Deleted Post Not in Trash
  77. Display content of metabox if filled in
  78. User profile Pick a premade Design/theme
  79. Recent activity query WordPress
  80. Echo the Last Child Taxonomy only (not parents)?
  81. What would causes search to return incorrect results?
  82. Problem with WP_Query loop and search term
  83. website is not loading home page (moving from one server to another server)
  84. Swap home page based on user role, Elementor layout breaking
  85. Customized Blog/Latest Posts Page
  86. Password Protection issue
  87. Search only for posts with specific metadata?
  88. how to edit or remove the dashboard footer message [duplicate]
  89. How to submit form data in the same page in WordPress without reloading the page?
  90. Translate site in own text-language [closed]
  91. Pull A Single Post Prior To Running wp_query
  92. How to work around the bug which prevents custom menus from being deleted?
  93. Create a folder if it doesn’t already exist
  94. How to remove the tagline from the HTML ?
  95. Custom table or form
  96. How I can add blog in my magento site?
  97. Getting Custom Field value in WP_Query
  98. Adding Telescope / Meteor App to existing WordPress site
  99. Help needed renaming custom post
  100. Post interior margin in twenty eleven theme

Leave a Comment