Incredibly slow 30-40sec delay loading on front and back end

Hello,

I’ve received confirmation from our hosting support that Enfold Avia is the culprit for our incredibly slow site loading times and I have no idea what I can do to further resolve it. I’ve optimized the site as much as I can, i’ve done all the steps concerning updating everything, deactivating plug-ins, wordpress memory expansion, etc. Visitors have to wait upwards to a minute for a single page to load and it’s been the same on the backend making site changes.

Please help.

Here’s the stack trace support copied showing the theme being the loading issue…

Hi D******,
>
> Thanks for your patience. The brute force log ended up being a red
> herring. I was, however, able to grab a direct stack trace of one of the
> delayed requests, and was able to identify the theme as the source. The
> theme generated over 4500 SQL queries during the request, most of them
> duplicates. These are the top queries with hit counts:
>
> 4504 SELECT option_name, option_value FROM wp_options WHERE autoload =
> ‘yes’ /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/framework/php/function-set-avia-backend.php:841]
> */;
> 102 SELECT option_name, option_value FROM wp_options WHERE autoload =
> ‘yes’ /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/config-templatebuilder/avia-template-builder/php/element-manager.class.php:1057]
> */;
> 86 SELECT option_name, option_value FROM wp_options WHERE autoload =
> ‘yes’ /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-settings.php:525] */;
> 39 SELECT option_name, option_value FROM wp_options WHERE autoload =
> ‘yes’ /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/includes/helper-main-menu.php:182]
> */;
> 34 SELECT option_name, option_value FROM wp_options WHERE autoload =
> ‘yes’ /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/framework/php/function-set-avia-frontend.php:1718]
> */;
> 28 SELECT option_name, option_value FROM wp_options WHERE autoload =
> ‘yes’ /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/header.php:77]
> */;
> 18 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE
> post_id IN (3118) ORDER BY meta_id ASC /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/includes/helper-main-menu.php:182]
> */;
> 18 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE
> post_id IN (3009) ORDER BY meta_id ASC /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/widgetarea.php:86]
> */;
> 18 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE
> post_id IN (2929) ORDER BY meta_id ASC /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/includes/helper-main-menu.php:182]
> */;
> 18 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE
> post_id IN (2928) ORDER BY meta_id ASC /* From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/includes/helper-main-menu.php:182]
> */;
>
> This was by far the most frequent, and thankfully it references the
> specific file that called it:
>
> SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ /*
> From [
> purleveconnectedsolutions.com/puraccess-sensor-control-center-home-page/]
> in [/chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/framework/php/function-set-avia-backend.php:841]
> */;
>
> This is the function in the theme causing the issue:
>
> /chroot/home/purleveh/
> purleveconnectedsolutions.com/html/wp-content/themes/enfold/framework/php/function-set-avia-backend.php:841
>
> 825 if(!function_exists(‘avia_deep_decode’))
> 826 {
> 827 /**
> 828 * This function performs deep decoding on an array of
> elements
> 829 */
> 830 function avia_deep_decode($elements)
> 831 {
> 832 if(is_array($elements) || is_object($elements))
> 833 {
> 834 foreach($elements as $key=>$element)
> 835 {
> 836 $elements[$key] =
> avia_deep_decode($element);
> 837 }
> 838 }
> 839 else
> 840 {
> 841 $elements = html_entity_decode($elements,
> ENT_QUOTES, get_bloginfo(‘charset’));
> 842 }
> 843
> 844 return $elements;
> 845 }
> 846 }
>
> I don’t know what is causing this to only happen intermittently, but at
> least we have a definitive cause. Please refer this to the theme’s
> developer, or your own. If possible, disabling the “avia” functionality of
> the theme (whatever this is) may resolve the issue.
>
> Please let us know if we can be of further assistance.
>
> Thanks,

• This topic was modified 3 years, 6 months ago by dhadleyxelainnovations.