For example, let’s take almost any modern forum. When a message appears in a topic, it is marked with some kind of distinctive color or the like (i.e. how it hints that it has been updated). And for each user it is done individually. Question: how is it implemented? Thought about some options. But everywhere there is a huge table with over90000 records. Whether there are more “graceful” ways? 🙂
Thanks in advance.
Answer 1, authority 100%
90k is not huge. each message usually has a limited number of recipients. accordingly, we create a linked table with three fields id (index) msg_id and user_id, in which we add records about a new message, after viewing we delete the record by index.