Skip to content

Reduce fs_accounts option size, possible? #400

@lkraav

Description

@lkraav

🚀 feature request

Description

Option table optimization dictates to look at autoload payload first.

SELECT 'Autoload kiB' as name, ROUND(SUM(LENGTH(option_value)) / 1024) as value FROM wp_options WHERE autoload='yes'
UNION
SELECT 'Autoload count', count(*) FROM wp_options WHERE autoload='yes'
UNION
(SELECT option_name, ROUND(LENGTH(option_value) / 1024) FROM wp_options WHERE autoload='yes' ORDER BY length(option_value) DESC LIMIT 10)

fs_accounts is easily one of the heaviest options recorded. Only WC Memberships has a heavier payload, but it has the excuse of being the backbone of the business.

Autoload kiB 646
Autoload count 1,821
wc_memberships_rules 96
fs_accounts 86
woocommerce_tracker_ua 33
wp_user_roles 30
rewrite_rules 19
redux_builder_amp 18
_transient_wpv_transient_meta_keys_visible512 17
itsec-storage 15
wc_customer_order_csv_export_orders_custom_formats 11
wsblc_options 11

Describe the solution you'd like

Please find a way to reduce autoload option payload. Significantly. 10x less kB would be a nice goal.

Describe alternatives you've considered

Yes, I will just disable Freemius wherever possible. I don't want to and neither do plugin vendors.

Your thoughts?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions