We observe a heavy load (up to several minutes) of the upcoming Event block.
We use Moodle 3.9. Our site has about 30K active users. A teacher (who suffers from long waiting for Upcoming Events) participates in ~36 courses, each course has about 100 groups.
Is it such course-group-user structure that causes the long latency? How can we optimize the loading time of upcoming Event