I have a setup of three wordpress environments:
I use git/git-hooks to version control and deploy my code from local to staging to production. Similar to as mentioned here.
My website is affiliation based, product comparison site. I am using this price comparison theme to upload and show products (which are actually posts).
Currently I have more than a hundred thousands products uploaded. Obviously, without any caching, the site is taking huge time to load (around 10 seconds per page).
So I reckon using a caching plugin like W3 Total Cache or WpFastestCache plugin to preload the product and listing pages would help here.
However I am facing two problems here:
For the second problem, I hope something outside of the plugin might help. Or if by any chance I can generate the page caches on my local machine which is heavy enough (16 GB RAM, 8 core). The problem I can see using this approach is if the generated pages would be using localhost instead of my production website url inside their content.