[root993]

For a very large database where the count would be filtered based on status of the conversations and running this query for every single support channel would be expensive would it not?

[afandian]

Probably less expensive than Redis.

Given that the SQL approach is the standard one, I'd personally expect load testing to demonstrate that it didn't scale before doing something unusual.