Google gives the result for one of the sections of the site - 14 600 000. MySQL database groans, the query executes from 5 to 30 seconds
I made caching with saving cached files to a folder, and one cache for searches, and another one for users.
/cache/ 1.txt - это для юзеров /cache/ 1r.txt - это для поисковиков /cache/ 2.txt /cache/ 2r.txt /cache/ 3.txt /cache/ 3r.txt /cache/ 4.txt /cache/ 4r.txt и т.д.
Is it possible to do this naturally? Over time, 14,600,000 * 2 = 29,200,000 files will appear in the folder. The whole thing will take 2 - 3 months.
The file takes 17 kb on average. From here we count.
17 * 14 600 000 = 248 200 000 kb / 1024 = 242 383 mb / 1024 = 237 gb * 2 = 474 gb
It turns out that the folder will be 474 GB of files, the total number of which will be 29,200,000 files.
Do not bend the whole thing? What do you advise?
And do not forget - this is just one section of the site, and there are several.
With caching, the pages are loaded instantly.