laycookie
TTCTheo's Typesafe Cult
•Created by Sandip on 1/10/2025 in #questions
How to send messages to large number of people and is there ways for doing it
Storing new messages in something like redis, and then just wiping them from there after they got queried is also an option.
Mukomo also raised a good point, if it is possible to do something other than an exreamly large query every 5 minutes it should redistribute the load across time, which should help.
16 replies
TTCTheo's Typesafe Cult
•Created by Sandip on 1/10/2025 in #questions
How to send messages to large number of people and is there ways for doing it
Ya I can definitely see why they wouldn't want to. I belive discord actually had a similar problem, and made a blog post about it.
https://discord.com/blog/how-discord-stores-trillions-of-messages#heading-4
16 replies
TTCTheo's Typesafe Cult
•Created by Sandip on 1/10/2025 in #questions
How to send messages to large number of people and is there ways for doing it
Huh, heard of it once, and that is pretty much it.
Ya, can't help with much a side from recommending to try to shard it, or to move to a nosql database.
I assume the second is not something you wan't to do, but it is an option.
16 replies
TTCTheo's Typesafe Cult
•Created by Sandip on 1/10/2025 in #questions
How to send messages to large number of people and is there ways for doing it
But is it mysql, litesql, postgresql or something else?
16 replies
TTCTheo's Typesafe Cult
•Created by Sandip on 1/10/2025 in #questions
How to send messages to large number of people and is there ways for doing it
Btw what database are you using?
16 replies
TTCTheo's Typesafe Cult
•Created by Sandip on 1/10/2025 in #questions
How to send messages to large number of people and is there ways for doing it
Just of the top of my head I would say you might want to shard your database.
There is probably other things you can do but sharding would probably bring the most significant gains.
16 replies