Custom field data is stored in the postmeta
table, and it’s likely that scanning through this table is causing slowness.
You should:
- install the debug bar plugin which will give you more insight into the queries that are being executed against the database – you’ll be able to see how long each query takes, and the actual SQL code that’s being executed.
- Find the queries that are taking a long time to run, and
EXPLAIN
them. This will give you a much better idea of what’s going on, and how to proceed.
Related Posts:
- Should I use Transients with W3 Total Cache APC Caching? [closed]
- What is the most efficient way of querying posts based on visits and date for current day?
- Slow SQL_CALC_FOUND_ROWS Query
- Transient pagination not working properly
- Get the post permalink within the loop but without additional DB query
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- Minimize database queries to user tables?
- Slow page loads due to WordPress Core Query
- No results found from a $wpdb->get_results() query when trying to join more than one meta key query
- Transient api Caches confused
- Is it possible to query from external database? [duplicate]
- What is the best way (regarding performance) to set transients for logged in users?
- How to set up hierarchical relationships without using plugins / meta query
- Using Transients
- I am officially missing something about transient posts
- Disable (or limit) queries when certain content (or data) is not needed (or showed)
- How to get meta key list efficiently?
- update_post_meta performance in a loop woocommerce
- update_post_meta performance in a loop woocommerce
- WP_Term_Query->get_terms() very slow query for WordPress filter
- wpdb get_results() returns only 2 rows
- Website goes slow down after importing long database
- WP_Query always returning the last custom post
- Optimising amount of calls to custom fields
- how to use transient method?
- When should you use WP_Query vs query_posts() vs get_posts()?
- How to query for most viewed posts and show top 5
- Differences Between WP_Query() and get_posts() for Querying Posts?
- Add indexing to meta_value in wp_postmeta
- Custom WP_Query order by post_meta and (author) user_meta
- WP_Query for WooCommerce Products
- Get posts by menu ID
- Export wordpress table to excel
- Perform query with meta_value date
- get_the_title($postID) OR get_the_title()?
- Add and in the header while looping over custom query in page template
- Stop all SQL_CALC_FOUND_ROWS wordpress queries
- How to find if a post with custom_field == X exists?
- How to speed up wp_query, took more 5s to run against 100k posts
- Transient caching for wp query
- How do you query wordpress posts using a math formula between multiple meta field values?
- Custom Post order for homepage
- Page navigation doesn’t show when query category
- Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
- Query all published post AND attachment with specific mime type
- Add quicklink to in the Admin posts page where I can query by a meta_key
- Get all products which have both product category
- unable to retrive parent page information
- Fastest way of counting posts of a custom post type in a specific taxonomy term?
- Use more than one query, but prevent duplicates – at scale!
- Is it a good idea to improve meta query performance by adding tax query?
- How to display user order by role
- How to use the query hook/filter?
- WP Query related posts by tags
- Order by summing multiple values
- Check if loop has any categories?
- How to access custom WordPress database tables
- Query only the posts with a post format of “audio”
- pre_get_posts – Trying to get property of non-object warning
- WordPress query posts with multiple post_meta data
- Update query for wp_posts and wp_postmeta
- Slow Query On Search
- WP_Query with page_ids in arguments without a result
- Write WP Query that selects posts that are part of the same two categories
- Insert images into wordpress post with a query
- WP_Query meta compare must include ALL array values
- Prioritising and Ordering Posts By Category Name Using A Custom Loop
- Filter products on category AND tag
- Why last row deleted when refresh page
- pre_user_query vs pre_get_posts
- Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
- Query a database based on form input then output to another page [closed]
- Adding nofollow to all the post links in get_posts with pre_get_posts or WP_Query
- Meta query orderby meta_value_num sorting by role first
- How to extend WP_query to a specific table?
- Add to search posts query array with post IDS which will appear first
- Query by meta value (add a dropdown of all values)
- How to show terms from another taxonomy
- Showing the correct number of posts_per_page when avoiding the use of post__not_in
- My entry results are not consistently alphabetized
- Ignoring ‘a’ when sorting posts
- Custom query for tag and custom tag from 2 post type
- WP_Query secondary query failing
- Search Functionality broken by the wp 4.2 update
- Issue attempting a wp_query_posts with tags
- wp_query – Modify $query to include duplicate content
- add_query_vars does not work
- Divide WP_Query posts by date & post type
- Retrieve posts in custom post type and specific taxonomies
- New WordPress WP Query using posts from certain categories
- Get the number of rows from $wpdb->get_results not working
- Get Child Custom Post Content on Single.php?
- How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
- WordPress Admin Page Slow. Customer Post Type is the slowest
- Pre_get_post on CPT archive page
- Get posts that were most recently tagged
- SQL query into to WP query
- Use meta query only 3 or more results?
- Search results stuck on page 1
- Use value from meta key array for use in WP_Query