Hot answers tagged schema
The "Best Way" is probably to do it the former way, calculating the accurate count of messages and friends, etc is going to be easier to manage on the application side. Performance will obviously depend on how many messages and friends, some variables on the database server, and indexes. A third solution would be to use a caching layer (like memcached) to ...
Only top voted, non community-wiki answers of a minimum length are eligible