Hello all.
I am wondering what is the best way to track viewed topics (on a per user basis) for a forum site. It doesn't seem very practical to create a table and add a row (containing the user id and topic id) everytime a user veiws a different topic (here the row would only be added if the combination of user id and topic id didnt already exist in the table). It seems that such a table would grow quite large very rapidly. Or is this the standard practice???
I was thinking of a possible alternative in which I could add a column to an existing database table which already holds the preferences. stats, etc of each user and fill it with a text string. Each time the user views a topic, the text string is appended with a delimiter character of some sort along with the newly visited topic Id. This would be simple enough but how would i iterate through the string to f ...
Go to the complete details ...