How to keep track of potentially 1000s of events participant cap's change?

[chouzar]

I just noticed a similar threath at Should I use GenServer for this? - #5 by lucaong

@benonymus

I want to track the capacity in real time from the db basically if i go with that solution that keep running all the time

Yeah, so with a GenServer you could “poll the database” each x seconds to keep track of current state.

You could keep a “cache” whenever the cap changes (so you would change it in the database, but would also keep it in memory for real-time purposes). But this sounds clumsy if you have the database at hand.