I would like to ask again here:
In the Matomo help, under “Tips for Medium to High Traffic Websites” (https://matomo.org/docs/setup-auto-archiving/), there is a recommendation of 512MB RAM. The recommendation for the app server is 16GB RAM (https://matomo.org/docs/requirements/).
From both, I understand that the PHP archiving process should not require more than a few GB of RAM. My PHP archiving process fails on the annual report even at 16GB of memory per PHP process.
How can it be that the archiving process with the above configuration requires such a massive amount of RAM? Are there ways to reduce this? How can I analyze the problem further? Is it recommended not to raise the above configurations?
Thanks a lot for the help.