Our users are complaining about Behaviour->Pages is taking a long time to open in certain month views with a lot of page views and also the year view. We have no problems with the first months of this year but in may we had about 13 million page views and 11 million unique and the Pages view for the whole month takes somewhere between 20-30 minutes to load. Previous months have about half the amount of page views and takes a couple of seconds to load. We do log imports and run cron archiving every night. Are these views not pre-processed kind of like the Vists Log or do we have some kind of misconfiguration?
I am in the process of migrating to a new machine run the imports in parallel at the moment while tweaking the new server and I see the same thing on that server.