Novu is slow even after creating indexes
Hi everyone, we've self-hosted novu and its quiet slow.
Thanks to Novu team's old responses in some of the thread, we found and created indexes based on
However, even after creating indexes, its quiet slow and uses a lot of CPU. It uses 100% CPU (on M50 - 8vCores, 32 gigs of RAM).
It uses 100% CPU and the query times are
The main spike we see in screenshot is when we have a schedule. On an average there are 20-25k triggers throughout the day that goes out at the scheduled time.
I've noticed activity feed on frontend load quickly compared to what we had without indexes.
Is this expected? If not how can we improve this?
Any help would be appreciated
Thank you for your time and efforts.
(Lmk if I should move this to #
│community-self-host)
Thanks to Novu team's old responses in some of the thread, we found and created indexes based on
lib/dalHowever, even after creating indexes, its quiet slow and uses a lot of CPU. It uses 100% CPU (on M50 - 8vCores, 32 gigs of RAM).
It uses 100% CPU and the query times are
>20sThe main spike we see in screenshot is when we have a schedule. On an average there are 20-25k triggers throughout the day that goes out at the scheduled time.
I've noticed activity feed on frontend load quickly compared to what we had without indexes.
Is this expected? If not how can we improve this?
Any help would be appreciated
Thank you for your time and efforts.
(Lmk if I should move this to #
│community-self-host)
