Re:Ask HN: Is there a way to efficiently subscribe to an SQL...
by eloff on Friday April 23, 2021 @02:10PM
(#26917476)
Because this can be done in a background batch job during off-peak hours, there's no harm in throwing 10K queries at the database - you should be able to run a 100x that with commodity cloud hardware without noticeably impacting performance, provided you take care to not just throw queries at the db at the max rate it can handle.
The simple approach is best here IMHO.