Self-teaching SQL and other programming languages
Scroll to see replies
Original post by jenhasdreams
Her reply 
Yes we store the number of posts against each user in the user table, which is updated whenever a post is made. It would be very slow to calculate the number of posts for a member every time that member profiles is loaded, as there are over 5 million posts.
Yes we store the number of posts against each user in the user table, which is updated whenever a post is made. It would be very slow to calculate the number of posts for a member every time that member profiles is loaded, as there are over 5 million posts.
Fair enough, good point. Though I still think it all depends on the situation though. In some other situations, it would be easier and better to count the number of records, and in some situations it would be easier and better to store it separately.
Well, that's something new I learnt today.
Quick Reply
Related discussions
- Kingston University Computer Science
- Nottingham Computer Science
- CIE A Level Computer Science Sucks!
- Can you do have a career in computing with A levels in Bio, Chem, and Psychology?
- GCSE Computer Science - Struggling with Networks
- Data science bsc at LSE? (experience, advice)
- Undergraduate Mathematics
- Next step from beginning [python]
- Nottingham hub error?
- computer science/ software engineering help
- What to include in a Computer Science Personal Statement
- Learning a new programming language - which?
- MSc Computer Science (conversion course) - 2019/2020
- How likely am I to get offers from Unys?
- To med students in Ireland: about your interpersonal experience and campus life
- NEA computer science A level Django
- Imperial MSc Machine Learning and Data Science (Online via Coursera)
- Birkbeck, University of London - MSc Computer Science Online Reviews
- OCR Computer Science Paper 2 GCSE 2023
- Need Masters but hate education
Latest
Trending
Last reply 3 days ago
YouTube Vs Spotify Which is Better Platform for musiciansLast reply 2 weeks ago
Touch screen doesn’t respond sometimes on iPhone 11Last reply 1 month ago
what kind of laptop to bring to uni?! macs vs windows, etc.Last reply 3 months ago
noise cancelling headphones suggestions for uni students?Trending
Last reply 3 days ago
YouTube Vs Spotify Which is Better Platform for musiciansLast reply 2 weeks ago
Touch screen doesn’t respond sometimes on iPhone 11Last reply 1 month ago
what kind of laptop to bring to uni?! macs vs windows, etc.Last reply 3 months ago
noise cancelling headphones suggestions for uni students?
