Minimizing or bypassing a slow query in the results

  • Resolved fightsmarttrav

    (@fightsmarttrav)


    3 months, 3 weeks ago

    Hey guys,

    So, it would appear that my membership plugin is regularly writing and deleting MASSIVE entries in the wp-options table. I have no idea why.

    My problem is that these entries are so freakin huge that I can’t even scroll past them to see what the other slow queries are… I’d like to cache them with Redis, but I have no idea if that’s possible because it’s seemingly an infinite scroll.

    I made a video if you want to see what I’m dealing with:

    https://www.dropbox.com/s/eqmdxx6de9z3c3v/for%20query%20monitor%20support.mkv?dl=0

    Is there ANY way that I can minimize or skip this query to see what the other slow queries are… in case I can actually cache them and improve the load speed of this page?

    As a coding guru yourself, do you have any idea what kind of diabolical maniac would be inserting something like this into the wp options table on every page load??? It seems… insane.

    Anyhow, thank you for your time and help.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author John Blackbourn

    (@johnbillion)

    WordPress Core Developer

    Wow, that’s a monster!

    To address your immediate problem, you can press cmd+down on a Mac to scroll to the bottom of the table (after clicking on it to focus it). That will allow you to get past the problem query.

    I have so far avoided truncating long queries in Query Monitor because inevitably the info you need is inside the truncated part, but I think collapsing a long query and having a toggle to open it up would be a good idea. I’d add it to my todo list.

    Your best bet is to contact the author of the problem plugin to show them what’s happening. It might be a compounding bug in the plugin that needs to be fixed.

    Good luck!

    Thread Starter fightsmarttrav

    (@fightsmarttrav)

    Hey John,

    Thanks for the reply!

    I’ve written to Optimize Press, no idea how they’ll handle it. All of their page builder data is stored in post meta, so this could somehow be ‘normal’ operation.

    Weirdly enough, when I drag that browser window to a different screen, a scroll bar appears.! When I drag it back to the main screen, the scroll bar stays for a second, and then disappears. Theres some kind of layout issue where QM seems to dislike my largest screen.

    if you need me to capture a video for you, I’d be happy to do so.

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