0
votes
0answers
17 views

Is MySQL query_cache useful for WordPress?

Starting from 5.6, if you use InnoDB as the default engine and query_cache is now officially disabled. We've a quite moderate traffic wordpress site and experience a major downtime when we upgraded ...
1
vote
2answers
81 views

I have over 4000 posts, will querying some of them cause performance issues?

I am wondering if querying posts like this: <?php $args = array('numberposts' => 19, 'orderby' => 'rand' ); $posts = get_posts( $args ); foreach($posts as $post) { ...
1
vote
1answer
185 views

Advanced Custom Fields - Query Efficiency

For testing purposes I have edited page.php to have nothing other than: <?php while ( have_posts() ) : the_post(); ?> <h1><?php the_title(); ?></h1> <?php $site_options = ...
0
votes
1answer
50 views

Get multiple posts with some custom fields efficient

Is there an efficient way to get some posts with (some of) their custom fields in one go? I have a custom post with some custom fields and would like to create an overview page where I display all ...
3
votes
2answers
239 views

Very slow query

This query works, but it takes upwards of 20 seconds to run on a Quad Core dedicated server... How can I optimize this? $slides=get_posts( array('post_type' => 'any', 'numberposts' => 5, ...
1
vote
1answer
746 views

WP_Query Performance Issues with meta_query

I'm working on a custom template for a new theme that uses a WP_Query instance to select posts from 2 post types with 2 custom fields that are NOT empty. Depending on the section of the site, a ...
0
votes
2answers
299 views

Disable (or limit) queries when certain content (or data) is not needed (or showed)

Currently I am making a custom design for a site. The problem I'm seeing in Wordpress is about almost all data pulled out from the database. While in certain pages - like front-page.php - it only ...