If I understood this correct, there would be some options that could improve the performance impact, for example limiting the time range or building indizes. But apparently, it isn’t of a high prio for the devs.

Thank you. It seems that this is much more complicated than what I thought.

I’m not saying that it isn’t a good fit (after all, the fediverse encourages selfhosting) - but OP might get better help there.

Seems like a good question for a selfhosting community