Admin slow when plugin activated
-
Hi,
after migrate a site from dev to production, the WP admin is dramaticaly slow. If I deactivate your plugin, it works normaly and fast, any idea for this issue ?
We use the lastest version of your plugin with Thine forest Theme.
Thx in advance
John
-
The entire admin or just the OptionTree pages? And you are certain you are using 2.4.5?
Yes whe use the latest version 2.4.5
And which parts of the admin are slow?
Every parts of the admin are dramaticaly slow 45s for dashboard, 5 minutes for a complexe page with composer. If I deactive your plugin dashboard 0,7s complexe page 2s. Strange isn’t it ?
It is strange that it effects the entire admin panel since OptionTree should not be loading on those pages at all. Please install the Query Monitor and/or Debug Bar plugins and see if there are any obvious issues that pop out at you.
Also, how many Theme Options do you have in your theme?
We have following settings in Theme options
General
Display Tagline? ON
Enable Lightbox for WordPress Gallery? ON
Enable Page Comment? OFF
Blog
Override Post Meta Info? OFF
Footer
Display Footer Widget Area? ON
Footer Widget Area Columns 4 columns
WPML
Display WPML Language Selector? OFF
Reveolution Slider ONI try to check with Query Monitor and/or Debug Bar plugins
That doesn’t seem like enough options to make the admin slow down anyhow. I may need to get access to your site to see what’s going on for myself. Please install those plugins and send me login info, if you can, to derek at valendesigns dot com.
Query monitor report
Page generation time Peak memory usage Database query time Database queries 38,7391 12,9% of 300s limit 161 722 kB 61,7% of 262 144 kB limit 32,9474 SELECT: 23 951 SHOW: 6 INSERT: 1 UPDATE: 2 Slow queries Slow Database Queries (above 0,05s) Query Caller Component Affected Rows Time SELECT post_name FROM wp_posts WHERE post_name = 'media-4647' AND post_type = 'option-tree' AND ID != 0 LIMIT 1 wp_unique_post_slug()+ Plugin: option-tree 1 0,0696 INSERT INTO <code>wp_posts</code> (<code>post_author</code>,<code>post_date</code>,<code>post_date_gmt</code>,<code>post_content</code>,<code>post_content_filtered</code>,<code>post_title</code>,<code>post_excerpt</code>,<code>post_status</code>,<code>post_type</code>,<code>comment_status</code>,<code>ping_status</code>,<code>post_password</code>,<code>post_name</code>,<code>to_ping</code>,<code>pinged</code>,<code>post_modified</code>,<code>post_modified_gmt</code>,<code>post_parent</code>,<code>menu_order</code>,<code>post_mime_type</code>,<code>guid</code>) VALUES (1,'2014-11-20 03:29:52','2014-11-20 02:29:52','','','Media','','private','option-tree','closed','closed','','media-23899','','','2014-11-20 03:29:52','2014-11-20 02:29:52',0,0,'','') wp_insert_post()+ Plugin: option-tree 1 0,0607 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49,51,44,46,38) ORDER BY meta_id ASC update_meta_cache()+ Plugin: uxbarn-team 59 0,0568After we have incredible number of queries from your plugin more than 23000 queries ??
Like this one :23851 SELECT post_name FROM wp_posts WHERE post_name = 'media-23819' AND post_type = 'option-tree' AND ID != 0 LIMIT 1 wp_unique_post_slug()+ Plugin: option-tree 1 0,0013Incredible !
We have 24837 records in wp_posts table ?!
The issue was fixed in the latest release. However, it seems that I need to write a clean up script in a new hotfix to address all the records that were created by the change in 2.4.3 and remove them permanently. I’ll work on a fix for this. However, I need a database dump of an site that is experiencing the issue so I can properly solve it. Is there any way you could email me an SQL dump of your database?
I’ve downloaded it, you can delete it now. I’ll try and have a fix by tomorrow.
Cheers,
DerekThank you Derek
JohnPlease test hotfix version 2.4.6 of OptionTree before I release it today. I’ve tested that it works on my system with the DB dump, but would like someone to confirm it’s working well on their server and give any feedback before I release it into the wild.
https://github.com/valendesigns/option-tree/archive/hotfix-2.4.6.zip
Derek,
does it include a script to purge database ?
The topic ‘Admin slow when plugin activated’ is closed to new replies.