-
Posts
-
Hi Enfold team – Happy New Year,
I’ve been working with a developer on managing performance / wp_options and have found an issue much like Ref. https://kriesi.at/support/topic/cleanup-wp_options-table-aviaasset_avia-head-scripts/ from 2020 where the Enfold theme entries are the biggest offenders. We host on WP Engine.
What we see:
option_name
aviaAsset_css_filecontent length of option value is 604041 and 589.88KB in sizeaviaAsset_js_filecontent length of option value is 498428 and 486.75KB in size
Many others follow but not as large. Is the 2020 solution referenced above still valid? What steps should I take to rectify this situation?
Thanks!Hey Julie,
Try looking at the Enfold Theme Options ▸ Performance ▸ Show Advanced Options ▸ Unique Timestamp Of Merged Files And WP Object Cache Bug ▸ Fix WP bug, disable unique timestamps
This was added for this situation and should help.Best regards,
MikeHi again,
I did as you suggested and changed the setting. I reran autoload checker and I see no difference. Are we missing a step?
Thanks for your help and quick reply.
jHi,
Try disabling Enfold Theme Options ▸ Performance ▸ JS & CSS file merging and compression and enabling Enfold Theme Options ▸ Performance ▸ Delete old CSS and JS files, then clear your server cache, then check again.
Then once these old files are removed you can enable the above again, I don’t think this setting will resolve old files, only the new ones.
Otherwise try the other option in the dropdown: Disable unique timestamps onlyBest regards,
MikeI tried this on our site (both variances you described) and it did not work. Here’s what I’m seeing now… Other options?
Total Autoload Size
2419 KBAutoload top list:
# Option name Size
1 aviaAsset_css_filecontent 529 KB
2 av_alb_usage_av_hr 272 KB
3 aviaAsset_js_filecontent 254 KB
4 av_alb_usage_av_icon_box 145 KB
5 av_alb_usage_av_one_half 145 KB
6 av_alb_usage_av_textblock 93 KB
7 rewrite_rules 91 KB
8 av_alb_usage_av_heading 91 KB
9 av_alb_usage_av_social_share 68 KBHi,
Thank you for the update.
The entries aviaAsset_css_filecontent and aviaAsset_js_filecontent should be automatically removed once you’ve disabled the Enfold > Performance > File Compression settings. If this is not the case, make sure that the compression settings are disabled, then try to delete the entries manually. Unfortunately, the entries with the prefix av_alb_usage_ cannot be removed because they are used by the Advance Layout Builder.
Best regards,
IsmaelHi,
Have you tried doing a database search? The entries should be in the _options table. You could also run this query, but make sure to create a site backup or a restore point first. (!!)
DELETE FROM wp_options WHERE option_name IN ('aviaAsset_css_filecontent', 'aviaAsset_js_filecontent');Best regards,
IsmaelHi Ismael,
I did a backup – then a search and found both, then deleted them both. Next, I cleared server cache. Autoload report still showed them. I did another database search and they were both gone. Yet Autoload report still shows both. I had WP Engine clear cache on their end and still showed on Autoload report. I’m waiting on them to give me another clue. I can’t wait too long to restore or work will be lost by others.
Any ideas?Hi,
I do need to understand what the Enfold Performance settings should now be after those were deleted.
You can keep the default compression settings disabled and install a third-party compression plugin like Autoptimize or use the default compression options from your cache plugin. Re-enabling the default compression settings from the theme will just regenerate the database entries you’ve just deleted.
Best regards,
Ismael
- The topic ‘Performance and DB load’ is closed to new replies.