Hi @Ghan,
thank you very much for these indexes. We have the same issue for a while now and couldn’t solve this.
After applying these indexes loading user profiles improved drastically. There were some “worst case” profiles which took up to 30s to load. Now they show up in ~5s.
So thanks again and I hope there is some more potential to speed this up.
Kind Regards
Sascha
P.S. Even the /about - page takes up to ~20s to load. May this could be speed up as well.