Hi there,
Website: https://www.crn.in/
I have noticed that whenever my website got visited by users or my editor teams, website getting crashed or opening very slow.
I was checking the issue and found the issue is in DB ‘SQL_CALC_FOUND_ROWS’ this query continuously calling and its making slow down the my website.
Other side is on the same server i have another three websites with different theme, but they run smoothly without crashing.
Can you please give me the solution?
Thanks & regards,
Prathimesh
Hi Prathimesh,
What I can recommend in this situation is to use an object cache / Redis and you can also use the cache from flex blocks elements – https://forum.tagdiv.com/use-flex-blocks-cache-option/
Thank you!
Hi Calin,
We are using object / redis cache on our websites.
As you have mentioned about flex block, but on the Homepage we are not using flex block, we are using only Blocks and there is not option of cache in that.
So, how can we set cache on block things?
Thanks & regards,
Prathimesh
Hi,
Unfortunately the cache option is only on flex blocks.
If you want to make a few tests I will suggest to remove on homepage the youtube videos and for menu to replace all menus that are made using page or category with custom links – https://i.imgur.com/3TU1ttE.png this will reduce the number of queries and the website should become faster.
Thank you!
