Forum unread post implementation

Question

Asp.net mvc3 forum implementation. Part of the implementation is a feature that shows what posts have been read an what posts have not.

The way I have implemented it now is that I create an entry in my data for each user at creation of a new post, and then remove them as they are displayed to my users,I also delete all under entries older then 1 month.

I currently have 450 users, so it takes quit a long time to create them all.

I was thinking there must be a better way as large vbullitin or phpbb forums with more then 1000 users can do this without spending 2+ sek at post creation, to create all these entries, but I have not found it. I can see there some other questions about this on this site, but I have not found an answer I can use.

Answer 1

You need to record user's last activity but storing everything in the database will not be efficient. Due to that, you'll also need to set cookies to know what threads they viewed. A bit of a hybrid approach but there are some lengthily discussions about it here:

• Handling unread posts in PHP / MySQL
• How to show unread/read status of forum post's like vbulletin, phpbb, others?
• PHP forums - how to cope with unread discussions / topics / posts