Transitions is using raw data to generate its reports.
This is known to be slow on some high traffic installations see https://matomo.org/faq/how-to/faq_161/
Similar to unique visitors (see https://matomo.org/faq/how-to/faq_113/ ) we would also want a config setting to disable Transitions for specific periods.
Ideally this was configurable additionally per site as it can be useful when there are many lower traffic sites in there and only one or few high traffic sites like
[Transitions] ; applies to all sites setting_name=... [Transitions_61] ; applies only to site 61 setting_name=...
We would want to configure whether it's enabled for
day. If a range is selected and it's bigger than the not allowed period, then it should not work on that range. If only
month|week|day is allowed, then any range selecting more than 31 days wouldn't be possible. Maybe we allow to configure the max period like
Just a quick thought and naming could be likely improved. I guess once you allow month, it should also automatically allow week and day.