Grafana docker container has CPU spikes and failes to load huge dashboards from multiple datasources

I have reduce transformation on almost all visuzlizations (Reduce → Series to Rows / Calculations Total).

I set dashboard autorefresh to OFF, otherwise it doesn’t load…