We have a fairly large Piwik set-up that is tracking about 80 sites or so. and we average around 2 million pageviews a month between them all.
Everything is working pretty well and fast as we’ve followed the support guides for optimizing Piwik for speed and such but we are still having issues with our Custom Date Range.
I can select a day, a month and a year and it loads blazing fast, but if I select the custom date range for a year, it totally bogs out. It spins and spins and eventually will come back with “Oops, we’ve encountered a problem”. Even selecting for a custom date range for a month or two is taking various times to load (if it loads)
Is there any suggestions on what we could do to fix this issue? Any suggestions would be greatly appreciated.