Hi guys,
I now have the full superspeedy pack from WP Intense which includes a lot of database modifications.

They also encourage you to set as many non-essential WP_Options with Autoload YES to Autoload NO to speed up all uncached actions on a site.
https://www.wpintense.com/knowledgebase/managing-your-wp_options-table/

I have had to do an extensive review of transients generated by plugins and also items that auto load. The speed difference from optimising wp_options in the backend and front end on large sites is massive.

I want to apply this same method to Enfold theme itself.

If you run the following SQL command you can see Enfold typically has over 100 – 150 autoloaded functions.

select left(option_name,15) option_name, count( * ) total
from wp_options where autoload = 'yes'
group by left(option_name,15)
order by total desc
limit 100;

(Note you need to change wp_ to your database prefix if it isnt wp_)

You can also then run:

SELECT * FROM wp_options where option_name like 'av_alb_usage_av%';
SELECT * FROM wp_options where option_name like 'av_alb_usage_av%' and autoload = 'yes';

and
DELETE FROM
or
UPDATE

av_alb_usage_av has over 100 options:

av_alb_usage_av_blog
av_alb_usage_av_button
av_alb_usage_av_button_big
av_alb_usage_av_buttonrow
av_alb_usage_av_buttonrow_item
av_alb_usage_av_catalogue
av_alb_usage_av_catalogue_item
av_alb_usage_av_cell
av_alb_usage_av_cell_four_fifth
av_alb_usage_av_cell_one_fifth
av_alb_usage_av_cell_one_fourth
av_alb_usage_av_cell_one_full
av_alb_usage_av_cell_one_half
av_alb_usage_av_cell_one_third
av_alb_usage_av_cell_three_fifth
av_alb_usage_av_cell_three_fourth
av_alb_usage_av_cell_two_fifth
av_alb_usage_av_cell_two_third
av_alb_usage_av_codeblock
av_alb_usage_av_comments_list
av_alb_usage_av_contact
av_alb_usage_av_contact_field
av_alb_usage_av_content_slide
av_alb_usage_av_content_slider
av_alb_usage_av_countdown
av_alb_usage_av_feature_image_slider
av_alb_usage_av_font_icon
av_alb_usage_av_four_fifth
av_alb_usage_av_fullscreen
av_alb_usage_av_fullscreen_slide
av_alb_usage_av_gallery
av_alb_usage_av_gmap_location
av_alb_usage_av_google_map
av_alb_usage_av_heading
av_alb_usage_av_headline_rotator
av_alb_usage_av_horizontal_gallery
av_alb_usage_av_hr
av_alb_usage_av_icon_box
av_alb_usage_av_icongrid
av_alb_usage_av_icongrid_item
av_alb_usage_av_iconlist
av_alb_usage_av_iconlist_item
av_alb_usage_av_image
av_alb_usage_av_image_hotspot
av_alb_usage_av_image_spot
av_alb_usage_av_layerslider
av_alb_usage_av_layout_row
av_alb_usage_av_magazine
av_alb_usage_av_mailchimp
av_alb_usage_av_mailchimp_field
av_alb_usage_av_masonry_entries
av_alb_usage_av_masonry_gallery
av_alb_usage_av_metadata_item
av_alb_usage_av_notification
av_alb_usage_av_one_fifth
av_alb_usage_av_one_fourth
av_alb_usage_av_one_full
av_alb_usage_av_one_half
av_alb_usage_av_one_third
av_alb_usage_av_partner
av_alb_usage_av_partner_logo
av_alb_usage_av_player
av_alb_usage_av_playlist_element
av_alb_usage_av_portfolio
av_alb_usage_av_post_metadata
av_alb_usage_av_postcontent
av_alb_usage_av_postslider
av_alb_usage_av_product_button
av_alb_usage_av_product_info
av_alb_usage_av_product_meta
av_alb_usage_av_product_price
av_alb_usage_av_progress
av_alb_usage_av_progress_bar
av_alb_usage_av_promobox
av_alb_usage_av_rotator_item
av_alb_usage_av_row
av_alb_usage_av_section
av_alb_usage_av_sidebar
av_alb_usage_av_slide
av_alb_usage_av_slide_accordion
av_alb_usage_av_slide_full
av_alb_usage_av_slideshow
av_alb_usage_av_slideshow_accordion
av_alb_usage_av_slideshow_full
av_alb_usage_av_social_share
av_alb_usage_av_submenu
av_alb_usage_av_submenu_item
av_alb_usage_av_tab
av_alb_usage_av_tab_container
av_alb_usage_av_tab_section
av_alb_usage_av_tab_sub_section
av_alb_usage_av_table
av_alb_usage_av_team_icon
av_alb_usage_av_team_member
av_alb_usage_av_testimonial_single
av_alb_usage_av_testimonials
av_alb_usage_av_textblock
av_alb_usage_av_three_fifth
av_alb_usage_av_three_fourth
av_alb_usage_av_timeline
av_alb_usage_av_timeline_item
av_alb_usage_av_toggle
av_alb_usage_av_toggle_container
av_alb_usage_av_two_fifth
av_alb_usage_av_two_third
av_alb_usage_av_video
av_alb_usage_avia_sc_search

and there are also other autoloaded options from the theme including:
avia_stylesheet
avia_gutenberg_
avia_options_th
widget_avia-ins
avia_woocommerc

Plus others possibly in your installation vs mine.

Would it be possible to review these options and make it so those that only run in the back end of wordpress are set to Autoload = NO
Would it also be possible to provide a list of those that can safely be set to NO? I can then run an SQL command to set them to NO:

Like this:
update wp_options set autoload = 'no' where option_name like 'av_alb_usage_av_animated_numbers%' and autoload = 'yes';

Transients Review

SELECT option_name AS name, option_value AS value
FROM LkxroSS_options
WHERE option_name LIKE ‘%transient_%’
ORDER BY option_name

Anything Enfold auto generates that shouldnt be autoloaded?

• This topic was modified 2 years, 4 months ago by thinkjarvis.
• This topic was modified 2 years, 4 months ago by thinkjarvis.