One way to solve this particular problem of "number of unread rooms" is not to persist it in database at all. Send push notifications of new messages and have c

One way to solve this particular problem of "number of unread rooms" is not to persist it in database at all. Send push notifications of new messages and have client app to compute it client-side.