Plugin Slowing down WordPress

  • Resolved indyparker

    (@indyparker)


    7 months, 3 weeks ago

    Hi Ajay,

    We are having problems with your plugin slowing down our WordPress admin/site:

    Our hosting company has pointed this out and now it is starting to cause problems.

    —————————–

    This is what they say:

    This plugin contextual-related-posts is causing excessive usage in the database, it’s causing a lot of unnecessary processes and at times hitting limits which are in place to prevent consuming all available resources for your WP usage.?

    At times we are seeing a large amount of queries similar to:

    SELECT wposts.ID FROM wp_posts wposts, wp_postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = ‘_wp_attached_file’ AND wpostmeta.meta_value = ‘2022/06/Tejasswi-Prakash-to-make-Bollywood-Debut-in-Dream-Girl-2-f.jpg’ AND wposts.post_type = ‘attachment’;

    While they complete quickly 200-300ms at times we are seeing a larger spike which causes a high amount of CPU usage.

    This script specifically:

    contextual-related-posts/includes/media.php

    on line 494

    ———————————————————

    Please advise on how to get this fixed.

    Regards,

    Indy

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Ajay

    (@ajay)

    Indy,

    This is indeed the strange part of query that would slow it down – I’d have expected the main query to have been the one causing the issue.

    Can you turn on the plugin’s caching – the HTML cache option and tell me if this helps? This should directly load the images.

    Thread Starter indyparker

    (@indyparker)

    Hi Ajay,

    Thanks for your response. I will switch on the caching and check with our hosting support team to see if it makes a difference and let you know accordingly.

    Plugin Author Ajay

    (@ajay)

    Hi, just wanted to update you on this further. I’ve been looking into optimising that function and I believe I’ve been able to cut down some database calls. I’ll get this into a v3.5.0 release I’m planning.

    Will try to get a beta release of this out if you’d like to test it.

    Thread Starter indyparker

    (@indyparker)

    Hi Ajay,

    The caching has made some difference but not huge. Things are still slow.

    So, happy to test the beta – you have my email from before.

    Plugin Author Ajay

    (@ajay)

    This is the beta release: https://github.com/WebberZone/contextual-related-posts/releases/tag/v3.5.0-beta2

    I suggest testing this out on a staging site first before the main site as there are quite a few code changes that I’ve made in this release. It’s not fully production ready yet in my view.

    Thread Starter indyparker

    (@indyparker)

    Okay- will let you know when I get to test it.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Plugin Slowing down WordPress’ is closed to new replies.