Swift framework storing large number of auto-loaded data in database

[David]

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’;

[Rui Guerreiro – SUPPORT]

Hi,

Let me check this with the development team, you can always update those values in the database to “No” instead “Yes”.

-Rui

[David]

Hi Rui,

Please let me know if you have any update.

Thanks

[David Martin – Support]

Hi,

Let me check the status of this know with Rui.

From your feedback I see SQL referencing spb_history a lot, I’ll check if there is a way to disable this feature to help you speed up the PB.

– David.

[David]

Hi,

Thank you for your update.

Thanks

[Rui Guerreiro – SUPPORT]

No problem. For now you can delete every entry of the spb_history(it saves the page changes made with the page builder so you can undo).

Remember that a part of the autoload records could be from WordPress and other plugins.

-Rui

[David]

Hi Rui,

Thank you for your help. I will look into.

Thank you very much.

[Rui Guerreiro – SUPPORT]

No problem.

-Rui