@chronark@aarondfrancis I think this is a god use case for Planetscale Boost if is in your budget. I had a similar issue and I prefere just use redis and a few listeners to keep the count updated on very active records.
https://t.co/9BygsjyoJg
https://t.co/VxpWvmDtrU