Mysql-read records of announcement information to determine whether or not users are reading and recording

Website announcements or Insite emails determine whether the user can view the message. how can this problem be solved? Method A: Message ID: 5662 record table: xxx_logUID: 335 the user adds an information 5662 + 335 + time to enter the XXX -- log table. However, in this way, the pressure on xxx_log is relatively high, if 100,000 users send dozens of messages in a month, there will be a lot of resources. if you delete the record table, when the user enters the mailbox, all the messages are not read.

Website announcements or Insite emails determine whether the user can view the message. how can this problem be solved?

Method:

Message ID: 5662
Record table: xxx_log

UID: 335 add a message when the user views it.
5662 + 335 + time entering XXX -- log table

However, in this way, the pressure on xxx_log is relatively high,
If 100,000 users send dozens of messages in a month, there will be a lot of resource occupation,
If you delete the record table, you can see in the mailbox that all the messages are not read.