WordPress.org

Ready to get started?Download WordPress

Forums

EG-Series
Too much DB queries (1 post)

  1. egoipse
    Member
    Posted 1 year ago #

    My pages are usinng EG Series two years by now. It worked fine. Until now. As long as my pages' traffic grows, they need a lot of optimizations. One of them is reducing the MYSQL database queries everytime a post is visited. So, I decided to check how many queries my posts are generating. And discovered that EG Series generates almost 20% of them, which is too much. Every post assgined to a serie generates five queries. There's no other process that generates as much queries as EG series.

    Here's the database queries report with EG series calls:

    float(0.00029993057251)
        [2]=>
        string(412) "require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/outdoor_magazine/single.php'), the_content, apply_filters('the_content'), call_user_func_array, EG_Series->shortcode_auto_content, EG_Series->posts_shortcode, EG_Series_Core::posts_list, get_posts, WP_Query->query, WP_Query->get_posts, WP_Tax_Query->get_sql, WP_Tax_Query->clean_query, WP_Tax_Query->transform_query"
      }
      [17]=>
      array(3) {
        [1]=>
        float(0.000983953475952)
        [2]=>
        string(331) "require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/outdoor_magazine/single.php'), the_content, apply_filters('the_content'), call_user_func_array, EG_Series->shortcode_auto_content, EG_Series->posts_shortcode, EG_Series_Core::posts_list, get_posts, WP_Query->query, WP_Query->get_posts"
      }
      [18]=>
      array(3) {
        [0]=>
        string(47) "SELECT * FROM wp_posts WHERE ID = 15212 LIMIT 1"
        [1]=>
        float(0.000221967697144)
        [2]=>
        string(307) "require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/outdoor_magazine/single.php'), the_content, apply_filters('the_content'), call_user_func_array, EG_Series->shortcode_auto_content, EG_Series->posts_shortcode, EG_Series_Core::posts_list, get_permalink, get_post"
      }
      [19]=>
      array(3) {
        [0]=>
        string(47) "SELECT * FROM wp_posts WHERE ID = 15227 LIMIT 1"
        [1]=>
        float(0.000164031982422)
        [2]=>
        string(307) "require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/outdoor_magazine/single.php'), the_content, apply_filters('the_content'), call_user_func_array, EG_Series->shortcode_auto_content, EG_Series->posts_shortcode, EG_Series_Core::posts_list, get_permalink, get_post"
      }
      [20]=>
      array(3) {
        [0]=>
        string(46) "SELECT * FROM wp_posts WHERE ID = 7492 LIMIT 1"
        [1]=>
        float(0.000158071517944)
        [2]=>
        string(307) "require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/outdoor_magazine/single.php'), the_content, apply_filters('the_content'), call_user_func_array, EG_Series->shortcode_auto_content, EG_Series->posts_shortcode, EG_Series_Core::posts_list, get_permalink, get_post"
      }

    Every query from EG series is too expensive in resources (CPU, RAM) for servers. So, until this issue is solved, I have not other choice than uninstall the plugin and test another options.

    This plugin's code should be optimized. A combination of pre_get_post with taxonomy could solve this problem...

    http://wordpress.org/extend/plugins/eg-series/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic