WP-Rocket was deactivated, but the wp-content/object-cache.php file was still present. This file redefined the wp_cache_add in such a way that the method didn’t work, so all requests to get a single option value were resulting in a query to the wp_options table.
I deleted the wp-content/object-cache.php file and the page response time dropped to 2 seconds from a peak of 15 seconds, and the total number of queries to 288 from a peak of 15,000.
Related Posts:
- How can I create a meta_query with an array as meta_field?
- Query multiple meta key values?
- Is there a way of increasing the speed of this query?
- How can I query all users who registered today?
- Reversing the order of posts AFTER the query is performed
- what are the numbers between curly brackets in search query
- When/why does ‘$query->get( ‘tax_query’ );’ return empty?
- How to get link and title of next and previous post on single page
- Create pagination and order according to alphabet
- How to display Section for certain time
- Search custom post type by meta data
- Multipart/formatted MySQL query problem
- Remove [gallery] shortcode altogether
- query multiple taxonomy and show post count
- Categories and products in random order
- add_query_arg() XSS Vulnerability
- When add_query_arg() is necessary?
- Insert html after certain amount of posts?
- wp remove query
- Filter query posts by the count of metas for a meta key
- $wpdb->get_var not returning a result
- $args numberposts variable
- Save default value for empty or missing post meta
- Listing posts by grouping dates
- $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
- How to mass delete one line from all posts after site hack
- Change searched term
- Query Posts By Post Publish Date, but sort by Custom Meta Key
- How to export current year posts from WordPress?
- MySQL variable in query
- How to execute a SQL-query which contains multiple queries using $wpdb->query?
- Only show upcoming event or current events
- Why a URL with a query is always slower than that without a query?
- Maintaining Queries in URL
- How do I see the mysql query generated by get_posts( $args )?
- How to orderby multiple meta fields with another meta query
- Query posts using meta_key
- Modify users.php query with multiple taxonomies
- MySql Query very slow
- wpdb query problem to access previous 3 days posts
- WordPress Query wp-terms SLOW
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- How to change the amount of posts previewed on a page?
- Problem when try to add ++1 for user meta
- How to get events using multiple custom meta fields?
- Related post based on content
- Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
- Random Page Rewrite
- How to interfere to default search to make it search in custom fields?
- How to pull posts into two columns with different image sizes using $counter variable?
- Declaring a var, placing it in a query and using the output of the query?
- Select column name dynamically mySQL Query
- how do i register global query in template
- WordPress Mysql query and Duplicate
- Combining two meta_values within one row with query
- How to “orderby” the first array in a meta_query that uses multiply keys?
- Sort query_terms_list for post_tags alphabetically
- Merge CPT Taxonomy and Post Taxonomy in $query->set
- How do I get specific readable results from this query and array results
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Order posts ascending from posts in array
- Display data from phpMyAdmin with WordPress
- custom sorting media with multiple filters – error: not unique table/alias: wp_postmeta
- How can I get posts by 2 meta keys, prioritising one of them?
- How to create a filter and add query params to all links
- Get 2 meta values from meta key column
- SQL query to list all posts of specific post type with a specific set of associated postmeta values as a column
- WordPress add_query_arg from ajax and make url friendly
- My custom pagination not displaying
- Wpdb->last_query returns bad query
- implementing my wp_query using $wpdb class
- Category_in return empty
- WP search exclude last letter from string
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- modifying main query to query for ranges e.g. from 1999 to 2016
- Array/List Edit in Backend
- $query->set( ‘post_type’, ‘post’ ); not working
- How i make a custom sql query for Woocommerce
- Querying users by meta value and getting a strange answer
- Wpdb empty result only if language is Russian
- Include custom table in query
- How to fix this insert? Don’t work for me!
- Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
- Update vs Insert logic but the last key is always inserted?
- Query unique author ids with published post of type job
- Sort loop with query in the link
- About WP’s save_post action
- $wpdb: how to use a query as a base for another query?
- Multilingual WordPress page – using URL to determine language?
- Custom Query for searching through custom fields
- list or get meta_key where meta_value is ‘something’
- Conditional Tag Custom Querys?
- WP_Query with checkbox meta_query – WordPress [duplicate]
- query posts only works on the first page
- Custom Query for wp_posts using wp_postmeta
- What is the best way to cache pages and queries in WordPress?
- WP Query outputs three items within a div
- Query filter on custom post by current author in post widget for elementor query id
- Querying Posts from ACF Repeater Subfield Select Value