In my WPF app, I use two APIs, one GET to fetch all the new messages and one DELETE to remove all the messages once they are displayed. The messages are stored in a mongoDB collection. Each document in the collection represents one user, including fields user_id and messages array. Every week I would generate one message for each user and append to the messages array.
The issue I’m encountering is the GET API is called every 10 minutes to check for new messages, and it impacts poorly on the API performance because we have more than 10000 users. Is there an alternative for the APIs? I was looking into AWS SNS but it doesn’t seem suitable for my case.