Performance and DB querys

Daniel Peterer

• January 19, 2023 16:58

We have a lot of DB querys from Brizy and Brizy Pro issuing performance problems on our website. You will find the Stage-Version of the website here:

https://stage.zitbox.ch/

Brizy does over 140 selects just for the startpage:

Plugin: brizy	79 selects
Plugin: brizy-pro	62 selects

How can we reduce the DB querys and optimize the performance?

Thanks and kind regards

Benedikt

0

• 

  KC George

  • January 20, 2023 12:00

  Hi Benedikt

  On my test website https://codesk.brizytest.online/ Brizy and Brizy Pro makes 9 and 5 select queries respectively. The select queries on your website looks comparatively higher. I guess depending on the size of the website, the number of database queries may vary.      

  

  To get a sense of the size of your website, please share a screenshot of the 'Directories and Sizes' accordion under Tools - Site Health - Info tab. Please have a look at this screenshot. https://jmp.sh/MdSOMH7l

  Optimizing performance and reducing database queries may not have a direct correlation always. If you are using a predominantly static WordPress website and your website uses caching, the webpages will be served from your file system (cache) and not from your database. If you use a CDN service, your pages will be served by one of the CDN servers and not from your hosting server. Hence number of database queries may not always affect performance. 
  
  However, the database queries might have an effect if you manage a WooCommerce website. Performance may not be impacted by the number of select queries if you employ Object caching and Dynamic caching.

  If you are attempting to improve performance please consider these two suggestions.

  1. If you are not using a caching/optimization plugin, please consider using one. You could try WP Optimize for example.
  2. There are 20+ HTTP requests sent out by Buddypress plugin. Please temporarily deactivate the BuddyPress and Wbcom Designs plugins and check the difference in performance. If you see a significant difference in performance, please consider moving these two plugins to a subdomain.

  0

Please sign in to leave a comment.