I’m just about to launch a new WordPress site at work and I’m tuning everything to be as fast as possible. In trying to track down inconsistent performance I installed WP Tuner and discovered that the All In One SEO Pack plugin is sometimes driving up database loads like crazy, even with half of the options disabled.
On this page it’s adding 4.9 seconds to the page loading time. More, actually, since wp-blog-header uses less database time when AIOSP is deactivated.

On other pages AIOSP is only adding a couple of hundred milliseconds to the page loads.
When I set WP Tuner to “Show Everything” so I can see all queries, it’s obvious that AIOSP is doing SQL queries for every link on the page. Why I have no idea.
If I can’t make AIOSP behave then I’m going to figure out how to replicate the features. Adding nofollow tags to the appropriate pages is pretty easy. My theme framework can insert canonical URLs. I think I can create meta descriptions via custom fields and then code that into the templates.
P.S. When I contacted tech support at my Web host about sluggish performance one of their first questions was if I was using an SEO plugin. I had previously tried SEO Ultimate and it had the same problem.
You could try turning on the log slow query feature in mysql. That way you can tell exactly which component of SEO is slowing you down. This may be something your isp has to do but it’s worth a shot.
WP Tuner will show slow queries. It isn’t that AIOSP has a slow query. It’s that is runs dozens and dozens of queries on every page and they all add up.
Les,
How did you go with this, because I’m experiencing the same thing with wptuner and the AIOSP plugin.
its taking 79% of my db time.
Cheers
Benjamin
This seems to be caused by “aioseop_list_pages” in all_in_one_seo_pack.php. It ends up ripping through all of the metadata for all of your pages on every page load.
Commenting out:
add_action(‘wp_list_pages’, ‘aioseop_list_pages’);
in all_in_one_seo_pack.php greatly reduces the database load. The sacrifice seems to be that if you use the page list in a menu, it will have the standard titles, not the titles added in the AIOSP title option in the page editor.
.-= Eric Goebelbecker´s last blog ..Be The Change Blog Party =-.
The man who can’t tell a lie thinks he is the best judge of one.
Eric, I looked for the line you suggested and all I could see was
$aiosp = new All_in_One_SEO_Pack();
add_filter(‘wp_list_pages’, ‘aioseop_list_pages’);
not an add_action
Have I not looked carefully enough, or is this the line to comment out? I am not a good php person
Hi,
This post seems to be explaining what has happened to my site, it was running fine until I installed the SEO plugin, now it hangs repeatedly. I have some hardcoded metadata etc in the header, maybe I will just rely on this for my SEO.