Hello,
My client’s website has more than 12K posts. I had slow queries, which made the post load after 2 or 3 seconds, maybe more.
I am using Redis on a stage website and it is the same. Also, I am using RDS by AWs and the same.
It is a very serious problem as the website has around 8K users per day.
Please guide me.
Kindly, check
Hi,
For that traffic you’ll need a dedicate server https://i.imgur.com/JxDkHWz.png -> https://forum.tagdiv.com/requirements-for-newspaper/also what you can solo do is to use some cache of database to make it faster.
Also, if you have more blocks on pages, then the time will be longer because each block is searching in database using sql_calc_found_rows so, the more blocks you use more requests will be make.
Also, if you are using ajax filter on blocks -> https://i.imgur.com/baEwDLe.jpg, this will also request access to database.
If you check all those, then you should get some improvements!
I hope this will help!
Thank you!
Dedicated! I am using RDS by Amazon and a high CPU optimized instance. I spent over $1,000 per month just to stay alive by using full page caching and Cloudfront.
This is a serious problem. Please take more time to investigate and provide a proper solution.
Thanks
Can you please provide a link to your website? If you do not want to share it on forum, you can do it via email at contact@tagdiv.com I want to check to see what is loading on your website, the template structure and other things that maybe can be optimized.
Thank you!
I will but for your record I test same website with another theme and it is blazing fast.
So, I am sure now it is your theme issue NOT WordPress issue
