Hi, I am Gabriele Pennino a Senior Consultant in a tech company. We are currently developing a big website faceing 2 issues:
Homepage performance
The homepage is currently experiencing high loading times, sometimes reaching several tens of seconds, due to the large number of queries being executed simultaneously. This issue is further compounded by the client behavior, which retries any failed query, thus increasing the overall load and response times.
Build process optimization
The build process, which generates an output of over 30GB, has been modified. We removed the gatsby-plugin-image for local image generation, and we now fetch images directly from Drupal. We have moved the heavier queries into the templates. However, the slowest part is still the data fetching from Drupal. We also tested the incremental build, and while it improves the situation, the process still takes over 40 minutes without cache and around 30 minutes with cache. Additionally, some existing pages are still being partially recompiled, even if the data values have not changed.
I hope this information will help in addressing potential optimizations, and I would greatly appreciate your support on these two matters.