My blog has over 700,000 articles…
You need to look at your webhost and server. WordPress is perfectly scalable, but you need the hardware to back it up. That’s a database intensive query, and you need the MySQL server to handle it.
Run mysqltuner.pl https://github.com/major/MySQLTuner-perl to check your MySQL configurations and adjust cache and memory settings in my.cnf.
Related Posts:
- How to print the excuted sql right after its execution
- Pagination with custom SQL query
- Return only Count from a wp_query request?
- how does $wpdb differ to WP_Query?
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Query causing load because of SQL_CALC_FOUND_ROWS post counting?
- Use WP_Query with a custom SQL query
- How to make an activities stream mixing posts and comments?
- How can I connect to another WP database and use WP_Query?
- Get number of comments after modifying comment query
- How to change a custom query into a standard loop?
- How to count data records in wordpress which have same meta_value in wp_postmeta table?
- Should close $wpdb via $wpdb->close()
- $wpdb->insert inserting two rows in database
- Get the Plugin Which Triggered a MySql Query in WordPress?
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- Detect featured image among the attached images
- How would I format a query that depends on post parent taxonomy
- Mysql query LIKE not working
- Select from wp_post and multiple meta_value from wp_postmeta
- Order by custom table and multiplication
- How to correctly pass values to wpdb->prepare()?
- $wpdb select date range of posts
- What’s the purpose / logic of split_the_query in WP_Query->get_posts
- WPDB query – decrypting DB data
- How to delete taxonomy term when a wordpress user is removed?
- Custom Query num_rows returns wrong amount
- Getting post revision and printing them on the post content site
- Filtering posts from different categories into different section by doing WP_Query only once
- Iterating through $wpdb query without using get_results for large query results
- Query with search and subscribers only output
- wp_Qwery works to slow
- How to query custom post types with mixed AND & OR statements for custom fields
- Query most popular terms by taxonomy over 2 week period
- Which is faster wpdb & get_row or wp_query & ge_post_meta?
- Custom query: Get all posts that are from a certain category?
- How to access custom WordPress database tables
- How to pass orderby params to $wpdb->prepare()?
- Ajax future single post query doesn’t work when NOT logged in
- Conditional sorting with variable using WP Query
- Is it safe to access the underlying mysqli object from \wpdb for custom queries?
- Make a SQL query with wpdb in WordPress
- WordPress query posts with multiple post_meta data
- List of ways to access WordPress database?
- Specify strict ‘order by’ in WordPress query
- Does WordPress have something like Drupal’s DB API?
- get_post() is not returning correct value
- Disable (or limit) queries when certain content (or data) is not needed (or showed)
- get_var is neither a string, integer, or array …?
- Use have_posts() with array of post results retrieved by $wpdb->get_results
- how to translate countries output from wp database?
- What’s wrong with this wpdb query?
- duplicated posts when using pagination
- Passing a SQL query to the WP Query
- Save queried result into database
- Any way to use FETCH_KEY_PAIR with $wpdb?
- Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
- How to get user avatar via WPDB
- In which file to use $wpdb and its functions for database operations and queries in wordpress?
- What argument does my function need to echo get_results() query results
- complex query question
- Select Unique Posts for a List of Tags
- How To Use WP_Query To Get The Custom Post type Posts With Keywords
- Include post_status check within $wpdb query
- wpdb get_results() returns only 2 rows
- Optimising amount of calls to custom fields
- pre_get_posts or $where, which one to use?
- Fire query on ajax post url page
- Search Query that Includes Custom Table
- Custom query (author is post_author or meta co_author) with Pagenavi pagination
- WP_Query search by multiple meta key and distance
- Different sql queries count indicator on the main page [closed]
- wpdb LIKE request shows all database data
- Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
- How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
- how to use transient method?
- get_post_meta bringing back results, but $wpdb->postmeta doesn’t
- Is there another way to retrieve a post_id from post_meta other than a SQL query?
- Sort posts by custom taxonomy name
- Query Ignoring ‘exclude’ Parameter?
- merge two query arguments into one WP_Query call
- Adding a parameter to the default query
- Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
- While creating Block Themes in WordPress, how can I query custom posts for an Archive view?
- Array as ‘key’ in WP_Query
- Check the Specific Meta Key IF its Meta Value is Empty then… (WP Post Meta Query)
- WP_Query returns different results from get_posts() [closed]
- How to pass query string vars between admin pages?
- Query posts by Post title
- Why do I have to use pre_get_posts with custom WP_Query to reset posts_per_page?
- Custom Homepage Pagination using WP_Query
- get latest added term from taxonomy and insert into php variable
- Featured images loop for Orbit Slider
- How to do WP_User_Query for Nested Array value Inside Nested Array field
- How to use jQuery validation to set the search bar to accept only a specific input?
- Order & Orderby clause not working with custom query
- Select posts wich has no relationship in custom taxonomy
- Help in query for list links
- WP_Query issues with argument posts_per_page
- Search (Custom Form, Custom Search Result)