Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta

    (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.
    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.
Submit reply
Turn on thread page Beta
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Updated: February 16, 2015
Have you ever experienced racism/sexism at uni?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.