Hello Support,
We are working on optimisation of website. From our server’s support we came to know that “swift-framework plugin” saving large number of auto-loaded data. So can you help us what we can remove or why it is storing large of number data?
Here is what our server support said:
The first thing that stands out is the amount of auto-loaded data being inserted into your database by the swift-framework plugin. It seems to be storing large amounts of history as shown below.
mysql> SELECT LENGTH(option_value),option_name FROM wp_options WHERE autoload=’yes’ ORDER BY length(option_value) DESC LIMIT 20; 472140 wpmandrill-stats 302284 spb_history_9 254922 spb_history_61232 235024 spb_history_22311 149792 wp_installer_settings 136686 spb_history_24225 110733 mw_adminimize 90308 spb_history_22404 84702 spb_history_22395 76374 spb_history_24143 74179 spb_history_13073 56249 sf_atelier_options 47835 rewrite_rules 43223 spb_history_14152 43184 spb_history_56199 36572 prdctfltr_templates 36162 spb_history_22393 31652 spb_history_17305 28749 sf_atelier_options-transients 28579 woo_template
I would recommend working with your developer/plugin developer in order to determine whether that information needs to continue to be stored. As it stands, your options table has over 2MB of auto-loaded data. We want that total to be under 800 KB or so for good performance. Once that has been corrected, you are welcome to re-enable object cache. Below I’ll include a query that you can from from within phpMyAdmin that will calculate the total of the data I mentioned above.
SELECT SUM(LENGTH(option_value)) FROM wp_options WHERE autoload = ‘yes’;
.