200+ DB Queries & 14 MB RAM added when plugin is enabled.

  • Let me begin by saying that WP Offload Media Lite works, and does exactly what it says on the box.

    However, now that I’ve just started using the plugin with my website I have found some worrying results.

    I use the excellent Query Monitor to keep an eye on my website’s performance, and I’m dismayed to what happens after I enable this plugin.

    As mentioned in the title, I have seen an increase in both the number of DB queries and the RAM usage for a page where an offloaded media item is shown. To wit, 200+ Database Queries (of which many are duplicate), and 14 MB of RAM.

    What’s more confusing is even on pages where there are NO OFFLOADED MEDIA ITEMS, I am seeing ~200 DB queries and 5~6 MB of extra RAM all coming from WP Offload Media Lite.

    Surely if the media URLs are re-written to be served from Amazon S3 in the DB, there shouldn’t be any need for so many queries?

    How I tested these findings:

    • 2 Different Pages.
      One with offloaded media, and one with locally stored (default) media.
    • Activated/Deactivated Plugin.
      I activated and deactivated the WP Offload Media plugin each time.
    • 10 Times.
      Each of the 2 different page types were loaded 5 times with the plugin enabled, and 5 times with the plugin disabled; this makes a total of 10 page loads.

    The results were consistent each time. Every time WP Offload Media was enabled, I saw an unreasonable increase in the amount of DB queries and RAM usage. Query Monitor also clearly pointed to this plugin as the culprit.

    For the moment, I have disabled the plugin, and I will wait for a response from the support team. Hopefully this gets resolved as I would love to continue using the plugin.

    • This topic was modified 5 months, 2 weeks ago by dzainein.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi @dzainein!

    WP Offload Media Support Team here. Thanks for reaching out with your query! We would be happy to assist.

    Surely if the media URLs are re-written to be served from Amazon S3 in the DB, there shouldn’t be any need for so many queries?

    WP Offload Media does not update any content stored in the database to use cloud storage URLs. Instead, it dynamically rewrites native local media URLs to cloud storage URLs as they are retrieved from the database.

    The plugin does this to maximize compatibility with WordPress and third-party themes and plugins.

    https://deliciousbrains.com/wp-offload-media/doc/developer-guide/#rewrite-urls

    To understand your current setup, would you be able to send the debugging information from the Support tab on the site you’re having trouble with? You may redact/remove any sensitive info.

    1. Go to the Support tab of your install
    2. Scroll down to the “Diagnostic Info”
    3. Please copy the info and share it here, or provide the URL if you upload the info on a site

    If possible, please share the plugin queries that Query Monitor has identified as problematic.

    We look forward to your response.

    Thread Starter dzainein

    (@dzainein)

    Okay, here are some images showing the issue:

    Here is a sample of the duplicate queries:

    And here is the link to the Diagnostics with sensitive info removed:

    https://s3.ap-south-1.amazonaws.com/public.teeragers.com/teeragers.com-diagnostic-log-20240611125837.txt

    Thanks.

    Thread Starter dzainein

    (@dzainein)

    Hi there,

    Any updates? Just making sure my reply didn’t fly under the radar. ??

    Thanks. ??

    Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi @dzainein ,

    Thanks for your patience. Our developers are currently looking into this issue. It’s possible there is some issue with the object cache on your site.

    WP Offload Media rewrites URLs dynamically. The plugin caches the offloaded version of the URLs each time a URL is rewritten. This minimizes connecting to your database to retrieve the offloaded URL.

    One possible downside is if a site has a lot of images that are not offloaded. On page load, the plugin keeps checking if an image is not offloaded. I checked your diagnostics and it looks like you have 7 offloaded images against 248 not offloaded. This could be adding to the issue.

    I did mention the object cache. When we receive tickets about a site being slow when WP Offload Media is active, one possible reason is an issue with the object cache.

    Could you confirm for us if your external cache (Redis?) is correctly configured? One previous customer was able to resolve this by restarting their Redis object cache server.

    Let us know how it goes for you.

    Thread Starter dzainein

    (@dzainein)

    I understand. I tried disabling the Redis plugin (I use Redis Object Cache by Till Krüss) but it got worse. I am attaching screenshots below.

    I also tried restarting the redis server, but to no avail.

    SCREENSHOTS:

    Thank you for your assistance. ??

    Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi @dzainein,

    Thanks for the update.

    Do you still have WP_DEBUG enabled? Could you please check again whether there are any new relevant logs on the debug.log file?

    If it’s possible, another thing to try is to temporarily disable all plugins except WP Offload Media and switch to a default theme to see whether this improves the performance of the plugin.

    Then, enable each plugin one by one until the issue happens again to identify any conflicts.

    We look forward to hearing back.

    Thread Starter dzainein

    (@dzainein)

    Thank you for your assistance. I have tried disabling plugins and switching to a default theme (except the Query Monitor plugin of course), but to no avail.

    Nothing in the debug logs either, the plugin isn’t generating any errors/warnings but just makes a LOT of duplicate DB queries. Unfortunately it is slowing my site down by quite a bit, so for the moment I will not use it.

    Perhaps another time. ??

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.