-
Notifications
You must be signed in to change notification settings - Fork 90
Reduce fs_accounts option size, possible? #400
Copy link
Copy link
Closed
Description
🚀 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?
Reactions are currently unavailable