Performance issue in control panel

[colq2]

Hello! I'd like to report that we're experiencing poor performance with the control panel.

Specifically, these two endpoints are problematic:
/mapi/meerkat/comments/search
/mapi/meerkat/reporting/overview

Comments: ~900
Response time: 10s

I also had to increase the memory limit from 2048 to 4096. As we anticipate receiving an increasing number of comments in production, it's not ideal to keep raising the memory limit in tandem with the comment volume 😄

Through some debugging, I discovered that the materializeThread function is the primary time consumer.

I've noticed Issue #241 regarding planned performance enhancements. Is there a rough timeline for when these improvements will be implemented?

Have you or others noticed this performance issue? Do you think it's something we can address quickly?