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
EXPLAINthem. 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?
- Optimizing AJAX Query with Large Database
- When should you use WP_Query vs query_posts() vs get_posts()?
- order by numeric value for meta value
- Wp get all the sub pages of the parent using wp query
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Return only Count from a wp_query request?
- How to query for most viewed posts and show top 5
- WP_Query vs get_posts
- WP_Comment_Query pagination, delving into the unknown
- Usage of the new “posts_clauses” filter in WordPress 3.1?
- Make a WP Query search match exactly the search term
- WP_Query: query posts by ids from array?
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- Differences Between WP_Query() and get_posts() for Querying Posts?
- Sort posts by category name and title
- How to uniquely identify queries?
- Add indexing to meta_value in wp_postmeta
- Custom WP_Query order by post_meta and (author) user_meta
- Query WooCommerce orders where meta data does not exist
- WP_Query for WooCommerce Products
- pre_get_posts with get_posts
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Get posts by menu ID
- author.php with ACF and CPTs
- Query Custom Meta Value with Increment
- Export wordpress table to excel
- When should you use wp_reset_postdata vs wp_reset_query?
- Get posts by meta data OR title
- Identify which loop you are hooking into; primary or secondary?
- Perform query with meta_value date
- WP_Query ordered by custom field that is a date string?
- get_the_title($postID) OR get_the_title()?
- How to make an activities stream mixing posts and comments?
- Duplicate Queries
- How to query for a week using key => value WP_Query argument notation?
- Finding all results from database within 500 miles of the given latitude and longitude [closed]
- What is an efficient way to query based on post_meta?
- Show only oldest post by author
- Order posts by tags count?
- SQL query equivalent to WP User Query
- Use Transient API to cache queries for all posts in all categories?
- Add and in the header while looping over custom query in page template
- Stop all SQL_CALC_FOUND_ROWS wordpress queries
- How to get the posts published in last two days using WP_Query?
- Highlighting Sub topic in a post?
- Which custom query am I in and how can I access its properties & methods?
- How to count post type that has a particular term?
- Finding the next 5 posts
- how to retrieve specific product attribute value in an sql query?
- Dynamically Override Fancy Title – Part II
- Foreach-generated custom tax queries, each with an ajax “Load more” button
- Can not switch the queried post in pre_get_posts hook
- Slow speed and high CPU usage for my code. How to improve it?
- Multiple queries on Home Page – page load/site speed issue
- view queries made?
- How to find if a post with custom_field == X exists?
- meta_query on a date range using an array of values
- wp_transients | wp_object_cache VS SESSIONS & Cookies?
- WordPress custom archive page
- Should close $wpdb via $wpdb->close()
- How to speed up wp_query, took more 5s to run against 100k posts
- WP_query category__in not working, only pulls from first category
- How to detect custom query inside `posts_where` hook?
- Pass the same object to multiple widgets in a template with one query
- Is temporarily overwriting $wp_query a bad idea?
- Query Set Order By Author
- Filter WordPress posts by between parameter
- List the 5 most recent child pages
- Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
- Retrieve or Query Pages by ID
- Retrieve featured image (thumbnail) url from multiple posts with one query
- 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
- How to implement time filter to show random post 1 month for one category and 3 months for other categories