[Plugin: Dashboard Site Notes] Slowed my site to a crawl

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.

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!

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.

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

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: https://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!

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