SReview
SReview copied to clipboard
dispatch should be event-based
Currently, dispatch polls the database every 30 seconds. While that works, it has obvious drawbacks.
Instead, it should use Mojo::Pg::PubSub to listen for notifications, and the database should send those notifications from a trigger or some such. This will eliminate many delays.