I have encountered the same issue but with product attributes, since I had more than 20000 products and much more product attributes, the queries were very slow.
What I did was, in order to make it faster, wrote an small plugin converting tags to custom fields and then displayed those on the page, but in your case if you need the tag archive pages and its functionalities, I suppose there is no other way around it.
To avoid max_execution_time try to configure your plugin to execute tag conversion instructions in small chunks,For instance, From posts 1 to 2000 and 2000 to 4000 and so on.
Database indexing might help too.
Finally try to use a cache plugin such as wp_fastest_cache it helps in an immense degree.
Related Posts:
- Get posts by menu ID
- Slow SQL_CALC_FOUND_ROWS Query
- Order by custom table and multiplication
- why update and delete query not worked in custom table?
- How to implement a new row_count method in WordPress?
- how to get Nearby zipcode
- WP_Query with page_ids in arguments without a result
- Why last row deleted when refresh page
- WP_Query always returning the last custom post
- SQL query into to WP query
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Should I use Transients with W3 Total Cache APC Caching? [closed]
- Add indexing to meta_value in wp_postmeta
- Getting wrong relationship value in $args in wp_Query?
- How to order posts tag by tag?
- WP Rest API v2 return posts with specific tag
- Loop through all tags & output posts in alphabetical list
- What is an efficient way to query based on post_meta?
- Order posts by tags count?
- Stop all SQL_CALC_FOUND_ROWS wordpress queries
- How to count post meta key values for all posts in database
- How to search for posts IN OR title OR content OR author?
- How to get any tag ID
- WP_Query hit max joins… How else can I build a search function that uses custom fields?
- Get all posts without tags
- How to find if a post with custom_field == X exists?
- if statement on database query
- How to speed up wp_query, took more 5s to run against 100k posts
- Filter WordPress posts by between parameter
- SQL User Query by Multiple Roles using PHP
- Retrieve featured image (thumbnail) url from multiple posts with one query
- WordPress Query is taking more then 20 second and stuck on creating index
- Get the Plugin Which Triggered a MySql Query in WordPress?
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- What’s faster? One big query, or several smaller ones?
- Query post from all category with same tag on 1 pages
- Single meta_query query using OR instead of AND in request’s WHERE statement
- How to use MySQL’s MATCH AGAINST in WP_Query?
- Slow WP_Query for custom post type
- How to build a WP_Query using mulitple tags and using AND or OR operator between them
- Create WP_Query to search for posts by their categories or their parent/child categories
- Add “Category” to Mysql Query
- Mysql query and order meta value
- Help with WP_Query – Too many mySQL queries
- Using hook to use DISTINCT in a wp_query
- How can I make WP_Query get posts that have a tag but also have random other tags?
- Order by summing multiple values
- Show all data in database table and make it into an interactive table
- Wp query show post by author name or post title or post content
- inserting a post from an extern php file but post content doesn’t show on wp site
- No results found from a $wpdb->get_results() query when trying to join more than one meta key query
- database query with more than a couple meta hangs and doesn’t complete
- How to access custom WordPress database tables
- Order by most used tag
- WP Query with multiple tags by get the tags
- how update data through ajax and jquery
- Meta Query doesn’t works as espected
- Query Posts by Tag and exclude
- Get posts that do not have the same tags as current
- Using Transients
- Update query for wp_posts and wp_postmeta
- Slow Query On Search
- how to write wordpress query for multiple metakeys checking?
- Retrieve data from wordpress db via input and put those result in dropdown
- Display posts by tag
- Get posts with no tags?
- Query multiple meta key values for template
- Only show tag with the same id as the post
- SQL to join u3g_users & u3g_meta_value with repeating data
- Query a database based on form input then output to another page [closed]
- INNER JOIN custom tables – SQL Query
- How to get meta key list efficiently?
- How to get user avatar via WPDB
- One of two similar WP Query is very slow
- How to extend WP_query to a specific table?
- update_post_meta performance in a loop woocommerce
- update_post_meta performance in a loop woocommerce
- Case insensitive ORDERBY in wpquery
- getting posts by tags
- Order Posts By Custom Field That is an array of objects
- Separate by Category Post Type
- Multiple wpostmeta.meta_key
- I removed the “wp_rm_logs” table and am constantly getting this error
- Related Post by Tags Code
- I cannot get tax_query in get_posts() to work with custom taxonomy
- WordPress custom query by archive title
- Random posts in WP_Query when searching by tag
- Include post_status check within $wpdb query
- wpdb get_results() returns only 2 rows
- Issue attempting a wp_query_posts with tags
- Optimising amount of calls to custom fields
- Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
- How to count post meta key values for all posts in database
- meta_query dates from an array
- Parsing External Table Arguments
- Custom query_posts() parameter
- How to add a custom field and incrementing value for all the published posts
- Can’t seem to get an else statement correct? [closed]
- Custom WP_query in Jnews theme returns thousands of posts
- Get posts that were most recently tagged