• Resolved Persephone33

    (@persephone33)


    This has to be one of the coolest plugins *ever* but unfortunately, it slowed both the front & back end of my site to the pace of a turtle on massive dose of barbiturates πŸ™

    Images are loaded in parallel, and otherwise the site is lightning fast (both front & back), but this would have been the *perfect* way to communicate so many things to my helpers…

    If it could be optimised so that it didn’t slow the site, I would be its greatest envoy to everyone else!

    http://wordpress.org/extend/plugins/admin-dashboard-site-notes/

Viewing 14 replies - 1 through 14 (of 14 total)
  • The same thing here. After the latest update the plugin became unusable. Had to deactivate.

    Shame! Loved it!

    Sorry about that! I’ll take a look this weekend and try to get that resolved.

    Could you let me know what versions of php, mysql, and wordpress you’re using, along with whatever other plugins are activated?

    Same happened to me after latest update only.
    I run two self hosted wordpress blogs off the same server.
    The one with this plugin died, The other is fine.

    I disabled all plugins apart from this one, and still dead ( i killed it with ftp in the end )
    However, all i really had was Jetpack, twitter digest & mapmyrun embedder.
    Even with those off, and this only on, it was unuseable in dashboard and front end.

    WordPress 3.3.1
    Apache version 2.2.17
    PHP version 5.2.14
    MySQL version 5.0.95-community

    Nevermind, found the problem. The update script was running on every page load. It’s fixed in 1.3.1, which should be available in a few minutes.

    Note that the very first admin page you load may take a long time like you were experiencing before, but as soon as that’s finished it will be normal again.

    Thread Starter Persephone33

    (@persephone33)

    Thank you!
    I, too, eliminated all the other plugins one by one to see, and I even use P3 Plugin Profiler which scans your site and maps a timeline to see the server response for your pages and outputs a nice report as to which plugins take what time to load (front & back end), which take the most (i.e., how much each affects the page load speed), etc.

    I’m using WP 3.3.1
    Apache version I didn’t know where to look in cPanel (?) though I do know that it’s Apache and my hosting co. is really on the ball, so I would imagine it’s a very current version
    PHP version 5.3.8
    MySQL version 5

    I have a good amount of plugins installed:
    admin menu editor
    adsense insert
    auto-featured image
    bulletproof security
    capability manager
    codepress admin columns
    easy content templates
    featured page widget
    google xml sitemaps
    liste category posts
    P3 (plugin performance profiler)
    page-list
    paypal donations
    point and stare cms functions
    random posts widget
    regenerate thumbnails
    related posts thumbnails
    rss manager
    section widget
    simply show ids
    sm sticky featured widget
    subheading
    types
    ultimate tiny mce
    use google libraries
    visual form builder
    widgetkit (goes with my theme)
    wordpress download monitor
    wordpress seo
    wp admin microblog
    wp category post list widget
    wpdb spring clean
    wp sliding login/dashboard panel

    I realise that is a lot, but even with all of those, the page load time is like 0.24 seconds (parallelised media), but with DSN, it went to 60 seconds and more!!

    For the love of godzilla I hope you can (and do!) work this out because your plugin is really, really helpful and I think necessary for anyone who has less than tech-savvy contributors or clients…

    Thanks in advance!

    Thread Starter Persephone33

    (@persephone33)

    Ha, you fixed while I was typing up my long list – how awesome!! Thanks!! πŸ˜€

    Aside from this major bug that was just fixed, a couple people have also mentioned that the plugin itself is a bit slow due to an intense mysql query on each admin page.

    In case anyone checks this thread in regards to that (due to the thread title) I’d like to add that in the next week or two, I’ll rewrite that bit to get a speed boost.

    Thread Starter Persephone33

    (@persephone33)

    Thanks for updating it so quickly, but it’s still really slowing down the admin area – see this screenshot πŸ™

    Thread Starter Persephone33

    (@persephone33)

    Yeah, it shows that there are a lot of queries. I’ll wait to hear back from you here for when you update it, then I’ll try again.

    Update: the issue fixed here may still have left some lingering effects causing a site to run slow. Unfortunately I have to head off and can’t provide a complete fix, but the issue is that there may be loads of duplicate meta keys in the postmeta table. The quick fix is to run something like this (untested) which will delete the duplicate meta keys but will also clear all the note settings for admin notices and contextual help items, so you’ll then have to go through each note and reset them:
    DELETE FROM wp_postmeta WHERE meta_key = “_dsn_contextual_help”;
    DELETE FROM wp_postmeta WHERE meta_key = “_dsn_admin_notice”;

    I have to run off, but if someone else sees this before I get around to providing a “good” query fix that write a query that deletes all duplicate meta keys with identical post_id, meta_key, and meta_value fields where meta_key is one of those two fields (and thus doesn’t clear admin notice settings) I’d be incredibly grateful, since I don’t have time to write it and test it right now (and don’t want to be responsible for posting something that accidentally deletes more than it should).

    This page which explains how to easily delete duplicate meta keys: http://wordpress.stackexchange.com/questions/15209/how-to-remove-duplicate-custom-fields

    After running these queries, you can reinstall the latest version of the plugin and everything should be fine. Keep in mind the following queries will each probably take several MINUTES to run.

    Because they take so long and I’ve only done some quick testing myself, I still advise running the two simpler queries seen above in my previous post instead of these two below if you’re okay with going back and manually setting the notice/tab checkboxes on all of your notes again. Unless you have a ton of notes, it will probably be faster to do that manually than to open up mysql and wait for the following two queries to run.


    delete from wp_postmeta
    where meta_id in (
    select *
    from (
    select meta_id
    from wp_postmeta a
    where a.meta_key = '_dsn_contextual_help'
    and meta_id not in (
    select min(meta_id)
    from wp_postmeta b
    where b.post_id = a.post_id
    and b.meta_key = '_dsn_contextual_help'
    )
    ) as x
    );


    delete from wp_postmeta
    where meta_id in (
    select *
    from (
    select meta_id
    from wp_postmeta a
    where a.meta_key = '_dsn_admin_notice'
    and meta_id not in (
    select min(meta_id)
    from wp_postmeta b
    where b.post_id = a.post_id
    and b.meta_key = '_dsn_admin_notice'
    )
    ) as x
    );

    It will be a while before I can release an actual update that integrates these fixes (due to the fact the true fix here takes several minutes to run and would just appear even more broken to anyone who installed it, so I’ll have to write a more elegant fix that can be run quickly on upgrade).

    I also want to apologize again for any mess this caused anyone who updated to version 1.3. Despite just working on this plugin for free in my spare time, I still feel terrible for all the headache caused to anyone who updated. Sorry, and I hope you’ll stick with me through future versions!

    Thread Starter Persephone33

    (@persephone33)

    Ben, Ben, BEN! You’re still the best developer in the world, bar none!! Think of us as your testers πŸ™‚ and never, ever forget that we appreciate what you are doing for us, in your own time, for free. We sure don’t! So we helped you to find a way to make it better, think of what Edison said! (hint: he found ‘5,000 things that don’t work’) We are just helping you along in your way to uber-greatness. πŸ™‚

    Anyway, this you ARE the best developer in the world because you know what? You saw a need and you filled it. You haven’t just offered one custom widget, or one drop-down help thingie, NO! You have developed a comprehensive system, my friend, that seriously, no website developer (or administrator with lots of helpers) should be without!

    I speak for myself in saying that you have not only my undying appreciation but I will definitely stick with you through all your future versions.

    My hat, sir, is off to you, and, I hope you change your username back quick-like!

    I completely and 100% agree with Persephone33!

    Ben don’t even THINK about apologizing!
    This is a great plugin, and you have a great sense of functionality.
    Keep up the great work, and I’m looking forward to the next release!

    I have the same problem here…

    The Admin Panel became very slow since I installed the Site Notes version 1.3.2, however, I have reinstalled the 1.2 version & WordPress works perfectly.

    Greetings from Barcelona and Congratulations to Developers of Site Notes!

    PC-SERVEIS, DiseΓ±o Web

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘[Plugin: Dashboard Site Notes] Slowed my site to a crawl’ is closed to new replies.