Brizy, Dynamic Content and Photos - a lot of DB requests

Stefan Mocanu

• September 07, 2020 10:25

Hello,

I am using Brizy+PRO(2.0.7+2.0.4) and ACF. In those ACF groups I have a Photo element in which I upload a photo on the ACF form when making a page. Then, in the page builder Brizy, I use Posts element and have like this: 3 text fields, 1 email, 1 url field, 1 photo field. When I configure the Posts element containing all the fields above, the page load increases to 5 seconds and ~500 database requests. The posts element has 4 rows, 4 columns, so 16 dynamic content squares. The page has nothing else in it(for testing purposes). When the Image element is missing from the dynamic content, the page load is 1.5 seconds and the DB requests go down to ~150.

I know that you are currently working on the dynamic content posts, but the Image element in the dynamic content is making this feature excruciatingly slow... Please send a word to your developers not to miss this. Also, do you have a timeframe for the update containing the dynamic content fixes?

 

Thank you!

 

0

• 

  Sandra Prunici

  • September 08, 2020 08:49

  Hi,

  Could you please send us the URL link of the page where you encounter this problem and please add the images too. We want to check this. Also, could I ask you what dynamic tag did you set for the Image element?
  Thanks!

  Best regards,
  Sandra

  0
• 

  Stefan Mocanu

  • September 08, 2020 13:01

  Hello,

  

  This is the ACF Image field, and all the Image fields in all the custom forms are the same as below:

  

   

  With pictures: https://icechim.ro/test/ - the page load is minimum 4 seconds

  Without pictures: https://icechim.ro/test2/ - minimum 1.2 seconds. which is also high for that amount of content, especially when you have multiple dynamic content elements. the time increases with every dynamic content element

  The thing is that dynamic content has always been very slow to load. Even on a fresh install, only the DB and content migrated, it's the same result.

  And on a production page:

  https://icechim.ro/test3/ - with pictures, loading time on the third refresh: 15.35 seconds:

  

  It seems that you have over 1000 selects for 60 dynamic loaded pictures(eye counted). And the Database Query Time is awful...9 seconds.

  https://icechim.ro/test4/ - without pictures, loading time on the third refresh: 2.56 seconds, and 133 selects:

  

   

  I am planning to make a test subdomain, Only with Brizy+PRO+ACF with 1 form. I want to replicate the setup without additional stuff in the way. Only 16 squares. Also, the problem replicates if all the plugins are disabled, so it's not because additional plugins.

   

  Also, i don't have memcache/memcached activated. With memcached activated(i activated it today for tests, but now is deactivated), on the 3rd refresh of the page the page load is ~1.5 seconds. Please deactivate your caching mechanisms to see that there is a big problem on dynamic content part. Also, the caching mechanisms are only faking it's quick because it needs 2 full page loads of 15 seconds for the page to go into cache for 1 hour. After that, 2 refreshes are needed for the page to go into cache again for the next hour. And so on. I cannot serve the visitors expired pages that are older than a couple of minutes :)

  0
• 

  Sandra Prunici

  • September 08, 2020 17:33

  Hi,

  Thank you for all these details. Could you please try to optimize all images from the site? I run all three sites you share us in the GTMetrix and in general I found that the results are good (see here, here and here) and with few request but the low score you receive on the image, therefore I pay attention to this subject. I found that you add some big images (see here) and if they will be optimized they will be loaded faster. Brizy has integration with ShortPixel, you can use it to optimize also the Brizy images. In this article, you can found more details about this.
  Thanks!

  Best regards,
  Sandra

  0

Please sign in to leave a comment.