therehere3

First, thank you, I really appreciate the reply! Second, I like this "mark all read" solution as well. However, if I do go down the right of keep entries of a user id read thread id, would I still want to have a combined index on my DB of userid+threadid even though each insert will require a re-index. But if I don't use that as my index it will be creating a full table search correct? I don't think there is any other way around creating that index for it even though inserts will be slower. Would love to hear your thoughts.

Hi there! I have created a forums system on my website using PHP and MySQL. However, I would like to show a red unread icon showing the user that is logged in that they have not read this thread. The only way I can think of doing this would be to simply create a table with the user id and thread id when they view a thread so if it is not in this table, then simply show the red icon. However.... I see this being a problem since this table would grow INCREDIBLY long and INCREDIBLY fast. There has to be a better solution right? Any advice would help, thanks!