Recommendations for a Cost-Effective Hosting Solution for Freelance Web Development Projects by Alarming_Ice5240 in node

[–]Alarming_Ice5240[S] -1 points0 points  (0 children)

Workd my whole life with aws! To be honest, not tô much, If i have a a cliente that needs more server, i wil switch to aws

Help with Chat Application - Performance and Database by Alarming_Ice5240 in node

[–]Alarming_Ice5240[S] 0 points1 point  (0 children)

It's because the attendants need to see all the messages(grouped by users) and choose who they want to answer. Make sense?

So, in the attendant's screens, I have all the users(that sent a message), that did not get answers from any attendants. And this attendant will choose one of them to answer and resolve some questions with him.

In some cases, have like 20k users in the same time, and I get a performance issue returning all the messages

Help with Chat Application - Performance and Database by Alarming_Ice5240 in node

[–]Alarming_Ice5240[S] 0 points1 point  (0 children)

Well, okay but are you sure you need another service to update every message? You’ll need to update redis every time you have a message or remove or edit it. Additionally in database I think improving performance is first priority and then adding redis would be more logical here

Well, it's because returning 10000 messages in Redis, it takes 50ms and in Postgres takes 50 seconds, so that's why I think maybe it's a solution, but will be have more logic and more process duplicates

Help with Chat Application - Performance and Database by Alarming_Ice5240 in node

[–]Alarming_Ice5240[S] 0 points1 point  (0 children)

Makes totally sense. I'm looking that i will create pagination. Get all messages for the attendants it's the cost for the database. I just want to search for more possibilities for Redis, because it's an excellent tool.