-
AuthorPosts
-
June 13, 2014 at 9:16 pm #278723
Our host provider reported (see link to screen capture provided by WPengine) open SQL database queries caused by the Enfold theme. This is caused slowness on our site. Please provide a solution and/or configuration setting tips that would help with performance. I have the latest version of Enfold. Let me know what other information would be helpful to you.
Thank you!June 13, 2014 at 9:39 pm #278729Hey Julie!
Can you provide any other details on what the screenshot is showing. Where is it, when is it, is there a list of queries WP Engine has an issue with?
On my dev install for instance, which has been running the theme for over a year now I have 105 queries when viewing the dashboard and 64 when viewing a page while editing. Then 47 queries when viewing a page on the front end with a handful of content.
Regards,
DevinJune 13, 2014 at 9:44 pm #278732We had experienced a 502 outage. The tech took a look at the site on the backend and found the open queries most high (as pictured) on the theme. He found no issues with the other plugins. When you ask “where, when, and a list of queries”… my guess is you are suggesting that they can provide me line item details in a log? Please point me in the right direction so that I can get the proper info to you.
June 13, 2014 at 10:01 pm #278739The description is vague to the point where I’m not really sure what they could mean. This is the plugin I’m using to check all active queries that are used on the page I’m looking at when logged in as an admin: https://github.com/johnbillion/query-monitor
I don’t know what WP Engine uses but yes it should should something more specific than the image above.
June 13, 2014 at 10:33 pm #278750This reply has been marked as private.June 13, 2014 at 10:36 pm #278751This reply has been marked as private.June 13, 2014 at 10:39 pm #278752This reply has been marked as private.June 14, 2014 at 7:25 am #278840Hey!
I tagged this thread for Kriesi. I’m not sure if we can help you because no other user reported an “open SQL database queries” issue and it’s not feasible to rewrite the code just because your host doesn’t like it. I asked Kriesi to comment on this issue though. Most of the queries are triggered by LayerSlider – if you want to deactivate the plugin insert:
add_theme_support('deactivate_layerslider')
into the child theme functions.php file. You can try other slider plugins like Master Slider or Revolution Slider instead but I’m not sure if WPEngine accepts these plugins…
Regards,
PeterJune 14, 2014 at 1:38 pm #278868Peter
I appreciate your help thus far. I have purchased 4 Enfold themes and plan to use them on ALL our sites (more to come). I hope that there is a way to get this fixed. It is the best theme we’ve come across and really has made our sites look awesome. Any help you provide is very much appreciated.
jJune 20, 2014 at 8:54 am #281526Hey!
I am afraid I am not sure either what we could do here, especially since it seems to work fine for everyone else. I will see if we can somehow lower the number or improve the queries but since we are using only wordpress functions to fetch content from the database I am not sure if there is a lot we actually can improve…
Best regards,
Kriesi -
AuthorPosts
- The topic ‘Open SQL DB Queries’ is closed to new replies.