I am using Matomo as a service container on AWS ECS.
I have noticed that I have performance issue regarding insight performance (via API). It can take up to 50 seconds to get the reports. After getting the report the first time, it is much faster.
Now, I am running a daily cron archive. I use a second docker service with better ram and proc.
Would it be better to run an hour cron archive (instead of daily) in order to have already calculated insights performance or does the performance are calculated on each request ?
Thank you !