国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

I would like to ask all the experts, how do you design the chat database? Those who have experience can talk about their experience, and those who have no experience can discuss it together.

Current problems encountered:

Assume

There are 1,000 people in the group chat, and user a sends a message:

Then:

Plan A: Insert a record corresponding to 1,000 people in the group chat (required Insert 1000 records, very scary)

Plan B: Insert a record (the user has read it, how can the user delete a record? Add a corresponding relationship table??)

Others Solution: Use other storage methods, such as Redis, memecache, etc.? ?