We have the following parameters:
One instance, 205 websites, about 25 million page views in a month.
When I configure a segment query, it usually takes up to 10 minutes to display a result. Sometimes it is also the case that the browser runs into a timeout. In the time the data is collected, Piwik is no longer usable for the user.
Can these queries possibly accelerate?