• Resolved rajinderverma

    (@rajinderverma)


    Hello Tablepress team,

    From the logs, I can see that one of the plugins ‘Tablepress’ was causing immense load on the server in the form of heavy SQL queries.

    For now, I have disabled the mentioned plugin and server load starting to normalize.

    Kindly tell me how to use tablepress plugin properly!

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    What are the “heavy SQL queries” that you are seeing?

    Regards,
    Tobias

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    regarding your tweet at https://twitter.com/rajinderverma01/status/1133343733812908033:
    I don’t know where these queries are coming from, as TablePress does not directly run such queries. This seems to be a standard WordPress query.

    Regards,
    Tobias

    Thread Starter rajinderverma

    (@rajinderverma)

    Hello Sir,

    Thanks for your valuable reply, Cloudways server hosting support team had found that Tablepress plugin is producing heavy Mysql load,

    Here is the string i am receiving an error:

    fxzqyrsgug 116 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 394 fxzqyrsgu localhost fxzqyrsgug 85 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 437 fxzqyrsgu localhost fxzqyrsgug 55 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 467 fxzqyrsgu localhost fxzqyrsgug 24 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 480 fxzqyrsgu localhost fxzqyrsgug 12 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 491 root localhost 0 Query init show full processlist

    After disabling Tablepress plugin, the server runs smoothly! without any load… I have 3800+ posts on my website in which I had used tablepress,

    See screenshot:

    https://cdn.livechat-static.com/api/file/v2/lc/att-old/4817491/0d28e0448dbccef3f76727a41dc0d3c5/problem.JPG

    https://prnt.sc/ntzfmo

    • This reply was modified 5 years, 9 months ago by rajinderverma.
    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    I could imagine that this is maybe related to the TablePress search integration. Please try adding

    add_filter( 'tablepress_wp_search_integration', '__return_false' );
    

    to see if turning that off helps.

    Regards,
    Tobias

    Thread Starter rajinderverma

    (@rajinderverma)

    Hello Sir,

    In which WordPress file I need to add this code and on which line number?

    Kindly, tell me with a reference example of WordPress website!

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    ah, sorry for missing that ?? Please add this to the end of your theme’s “functions.php” file (but before the ?> if that exists).

    Regards,
    Tobias

    Thread Starter rajinderverma

    (@rajinderverma)

    I am using Newspaper V 8.5.1 theme with WordPress 5.2.1…

    Hello sir, I am not a techy guy. Therefore, I understand these things with some difficulty…

    Here is the function.php code: kindly tell me where to insert code with proper manner!

    <?php
    /*
    Our portfolio: https://themeforest.net/user/tagDiv/portfolio
    Thanks for using our theme!
    tagDiv – 2017
    */

    /**
    * Load the speed booster framework + theme specific files
    */

    // load the deploy mode
    require_once(‘td_deploy_mode.php’);

    // load the config
    require_once(‘includes/td_config.php’);
    add_action(‘td_global_after’, array(‘td_config’, ‘on_td_global_after_config’), 9); //we run on 9 priority to allow plugins to updage_key our apis while using the default priority of 10

    // load the wp booster
    require_once(‘includes/wp_booster/td_wp_booster_functions.php’);

    require_once(‘includes/td_css_generator.php’);
    require_once(‘includes/shortcodes/td_misc_shortcodes.php’);
    require_once(‘includes/widgets/td_page_builder_widgets.php’); // widgets

    /*
    * mobile theme css generator
    * in wp-admin the main theme is loaded and the mobile theme functions are not included
    * required in td_panel_data_source
    * @todo – look for a more elegant solution(ex. generate the css on request)
    */
    require_once(‘mobile/includes/td_css_generator_mob.php’);

    /* —————————————————————————-
    * Woo Commerce
    */

    // breadcrumb
    add_filter(‘woocommerce_breadcrumb_defaults’, ‘td_woocommerce_breadcrumbs’);
    function td_woocommerce_breadcrumbs() {
    return array(
    ‘delimiter’ => ‘ <i class=”td-icon-right td-bread-sep”></i> ‘,
    ‘wrap_before’ => ‘<div class=”entry-crumbs” itemprop=”breadcrumb”>’,
    ‘wrap_after’ => ‘</div>’,
    ‘before’ => ”,
    ‘after’ => ”,
    ‘home’ => _x(‘Home’, ‘breadcrumb’, ‘woocommerce’),
    );
    }

    // use own pagination
    if (!function_exists(‘woocommerce_pagination’)) {
    // pagination
    function woocommerce_pagination() {
    echo td_page_generator::get_pagination();
    }
    }

    // Override theme default specification for product 3 per row

    // Number of product per page 8
    add_filter(‘loop_shop_per_page’, create_function(‘$cols’, ‘return 4;’));

    if (!function_exists(‘woocommerce_output_related_products’)) {
    // Number of related products
    function woocommerce_output_related_products() {
    woocommerce_related_products(array(
    ‘posts_per_page’ => 4,
    ‘columns’ => 4,
    ‘orderby’ => ‘rand’,
    )); // Display 4 products in rows of 1
    }
    }

    /* —————————————————————————-
    * bbPress
    */
    // change avatar size to 40px
    function td_bbp_change_avatar_size($author_avatar, $topic_id, $size) {
    $author_avatar = ”;
    if ($size == 14) {
    $size = 40;
    }
    $topic_id = bbp_get_topic_id( $topic_id );
    if ( !empty( $topic_id ) ) {
    if ( !bbp_is_topic_anonymous( $topic_id ) ) {
    $author_avatar = get_avatar( bbp_get_topic_author_id( $topic_id ), $size );
    } else {
    $author_avatar = get_avatar( get_post_meta( $topic_id, ‘_bbp_anonymous_email’, true ), $size );
    }
    }
    return $author_avatar;
    }
    add_filter(‘bbp_get_topic_author_avatar’, ‘td_bbp_change_avatar_size’, 20, 3);
    add_filter(‘bbp_get_reply_author_avatar’, ‘td_bbp_change_avatar_size’, 20, 3);
    add_filter(‘bbp_get_current_user_avatar’, ‘td_bbp_change_avatar_size’, 20, 3);

    //add_action(‘shutdown’, ‘test_td’);

    function test_td () {
    if (!is_admin()){
    td_api_base::_debug_get_used_on_page_components();
    }

    }

    /**
    * tdStyleCustomizer.js is required
    */
    if (TD_DEBUG_LIVE_THEME_STYLE) {
    add_action(‘wp_footer’, ‘td_theme_style_footer’);
    // new live theme demos
    function td_theme_style_footer() {
    ?>
    <div id=”td-theme-settings” class=”td-live-theme-demos td-theme-settings-small”>
    <div class=”td-skin-body”>
    <div class=”td-skin-wrap”>
    <div class=”td-skin-container td-skin-buy”>BUY NEWSPAPER NOW!</div>
    <div class=”td-skin-container td-skin-header”>GET AN AWESOME START!</div>
    <div class=”td-skin-container td-skin-desc”>With easy <span>ONE CLICK INSTALL</span> and fully customizable options, our demos are the best start you’ll ever get!!</div>
    <div class=”td-skin-container td-skin-content”>
    <div class=”td-demos-list”>
    <?php
    $td_demo_names = array();

    foreach (td_global::$demo_list as $demo_id => $stack_params) {
    $td_demo_names[$stack_params[‘text’]] = $demo_id;
    ?>
    <div class=”td-set-theme-style”>” class=”td-set-theme-style-link td-popup td-popup-<?php echo $td_demo_names[$stack_params[‘text’]] ?>” data-img-url=”<?php echo td_global::$get_template_directory_uri ?>/demos_popup/large/<?php echo $demo_id; ?>.jpg”><span></span></div>
    <?php } ?>
    <div class=”td-set-theme-style-empty”></div>
    <div class=”td-set-theme-style-empty”></div>
    <div class=”clearfix”></div>
    </div>
    </div>
    <div class=”td-skin-scroll”><i class=”td-icon-read-down”></i></div>
    </div>
    </div>
    <div class=”clearfix”></div>
    <div class=”td-set-hide-show”></div>
    <div class=”td-screen-demo” data-width-preview=”380″></div>
    </div>
    <?php
    }

    }

    //td_demo_state::update_state(“ink”, ‘full’);

    //print_r(td_global::$all_theme_panels_list);

    /**
    * Show info message for logged users when API classes are not defined (maybe some TAGDIV plugins are not installed)
    */
    add_action( ‘get_footer’, ‘td_on_get_footer’ );
    function td_on_get_footer() {
    if ( is_user_logged_in() && ! td_util::tdc_is_live_editor_iframe() && td_util::get_check_installed_plugins() ) {

    ob_start();
    ?>
    <script>

    setTimeout(function () {

    confirm( “Did you disable any TagDiv plugins? \nWe’ve got some errors at loading API files. It could happen because of a disabled TagDiv plugin!”);

    }, 3000);

    </script>
    <?php

    echo ob_get_clean();
    }
    }

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    as I said, to the very end of the file.

    Regards,
    Tobias

    Thread Starter rajinderverma

    (@rajinderverma)

    Ok Sir, doing it..will tell you the response of this change, very soon!

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks!

    Best wishes,
    Tobias

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘‘Tablepress’ causing immense load on the server’ is closed to new replies.