Dashboard – Pages – Edit, grindingly slow

  • In the past few updates, I have seen the time to open a Page for editing go from about 1 second to 30 to 80 seconds.

    In the Dashboard, I can click on Pages, Posts, Plugins, Settings, and the Dashboard changes with 1 to 2 seconds.

    When I click on Pages, and then click on a Page to edit it, I typically wait from 30 to 80 seconds before I see the actual content.

    In FireFox Debug, I see that for the longest time, nothing happens, then things start coming in from the server and within 2 seconds the editing page is presented.

    I installed the Hearbeat Control Plugin and turned off Hearbeat all over, with no change.
    At one time, WP Editor Plugin was installed, I deactivated it and deleted it.

    The following Plugins are Activated

    • amr shortcode any widget
    • Custom Facebook Feed
    • Disable Comments
    • Full Screen Background Images
    • Heartbeat Control
    • Insert HTML Snippet
    • Login Security Solution
    • NextGEN Gallery by Photocrati
    • SOLDPress Premium
    • WP Clean Up
    • WP to Twitter

    As I was trying to learn and build a site, I was tolerating the extremely slow edit, so the following Plugins were installed, even after the slowdown had started, so they are most probably not a cause of the problem.

    • Custom Facebook Feed
    • Heartbeat Control
    • WP Clean Up
    • WP to Twitter

    I would dearly appreciate any insight as to what could be causing this, and I need to get it fixed, so I will work to find the problem. I hate to say it, but the problem appears to have begun with the last 3 to 5 updates, I canot be sure, as I do not edit/change/modify this website with daily frequency.

    neuron technologies real estate example

    Oh man, installing Heartbeast Control and turning off and then on Heartbeat appears to have broken NextGEN.
    I will fix NextGEN, however, the rest of the website appears to be working.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter tomkinsrichard

    (@tomkinsrichard)

    I fixed the NextGEN failure, Reset did the trick.

    I have performed the following;

    • deactivated all plugins
    • cleared all the various caches, WP and FireFox
    • clicked on Pages
    • It took 1 second to display list
    • clicked on edit for a page
    • it took 61 seconds to enter edit

    Seriously, there must be other experiencing this failure.

    What is wrong?

    Hi tomkinsrichard,

    Can you install the Query Monitor plugin and check if there are any slow database queries or so while opening the edit screens?

    Thread Starter tomkinsrichard

    (@tomkinsrichard)

    I cannot claim to have a strong understanding of WordPress, PHP programming and MySQL, however, over the years I have programmed in various languages, Oracle, PostgeSQL and SQL Server.

    The following query;

    SELECT DISTINCT meta_key
    FROM wp_postmeta
    WHERE meta_key NOT BETWEEN ‘_’
    AND ‘_z’
    HAVING meta_key NOT LIKE ‘\\_%’
    ORDER BY meta_key
    LIMIT 30

    clocks in at 40 to 45 seconds.

    The call says Component is CORE and the Caller is meta_form()+.

    I think that gives me a clue as to what is going on. This is a Real Estate website, the plugin I use is, SOLDPress, the developer uses meta_key of wp_postmeta to store the property attributes for every property.

    Poor Plugin design, they should have created their own table or at least their own rows/columns.

    Is there some way I can turn off or change the query as a short term fix while I badger the Plugin developer?

    The only way to turn that off might be to edit the plugin files and comment out the code involved. It might even break the plugin. You’ll need to contact the developer to actually do something about it.

    Good luck ??

    Thread Starter tomkinsrichard

    (@tomkinsrichard)

    The developer just got back to me. They are telling me that they will be creating a new, improved subscription service, Windows based with a subscription to Azure.
    Looks like a big money grab to me. Time to reexamine directions.

    Thread Starter tomkinsrichard

    (@tomkinsrichard)

    This is going to sound like a dirty solution, but,

    Looking through the PHP code for the Plugin, they make extensive use of,
    global $wpdb.

    Would it be possible/feasible to override $wpdb such that it could be made to point to a secondary WordPress database that the Plugin would use for it’s operation, separate from WordPress’ database.

    $wpdb and $wpdb_soldpress?

    That does seem like a dirty solution.

    Although, now that I think about it, maybe installing W3TC and enabling database cache on memcached(you’ll need memcached on the server) can be something worth trying. If you have an SSD server, you can try disk caching instead of memcached.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Dashboard – Pages – Edit, grindingly slow’ is closed to new replies.