Re:The Set data structure saved me from a world of pain
by root993 on Tuesday October 20, 2020 @06:39AM
(#24835840)
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?
[ Parent
| on HN ]
Re:The Set data structure saved me from a world of pain
by afandian on Tuesday October 20, 2020 @11:16AM
(#24838299)
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.