Live chat database design, recent contacts need to create separate tables?

The

requirement is something like this
I have a table to record the chat content, and the field looks like this

msgid
from
to
content
time

then I need to show the user"s recent contacts. Theoretically, I can query all the recent contacts from this chat list through sql, but now I need to delete the recent contacts and keep the chat records, that is to say, it is impossible for me to delete the recent contact records by clearing the chat records of the two people.
so do I need to create another list of recent contacts? And then maintain this list of recent contacts while both parties are texting each other?

Redis mysql

Mar.20,2021

it is recommended that you create a separate table to save recent contacts.
1. From a functional design point of view, the recent contact is an independent feature that does not rely on chat history, as you have already said.
2. In terms of system performance, there will be a performance bottleneck when the amount of data is large every time the nearest contact is calculated from the chat log table.

Thank you for inviting me. You're on the right track. It depends on your needs, but if you look at your needs, recent contacts need to be recorded for a long time, so it is recommended that you set up a separate table to save the relevant data. And this table does not require many fields, and the impact will not be great. Of course, a less good solution is to directly add a field to the corresponding user table to record the recent contact id in the specified format, but there are many uncertainties that may affect it and are not friendly to later maintenance, so it is not recommended.

Previous: Why can't my xpaht match?

Next: The weex create project definition name ends abruptly.

Annotation invalidation of dao interface using mybatis @ CacheNamespace cache
use mybatis to configure custom secondary cache. Using xml annotation can use < cache type= "com.test.dao.MybatisRedisCache " > to successfully use custom cache, but using @ CacheNamespace (implementation = MybatisRedisCache.class) on the dao i...

Java spring mybatis redis mysql

Feb.27,2021
After the order exceeds a certain time, the user does not confirm the receipt of the goods, which requires the system to automatically complete the confirmation operation, that is, to change the status of the order. Do you have any good ideas?
after the order exceeds a certain time, the user does not confirm the receipt, so the system needs to automatically complete the confirmation operation, that is, to change the status of the order. Do you have any good ideas? I have seen before that so...

Redis mysql php

Mar.03,2021
Now ordinary poker games (such as fighting landlords, Texas hold'em, enough level, etc.), what is used in the background?
1. What kind of record is used in the card game record? I think MongoDB would be better, wouldn t it? 2. Is the logic of playing cards in any language? Is it okay to develop with php ? 3. are the rules of the game and card logic quite difficult? ...

Mongodb redis mysql javascript php

Mar.10,2021
The realization plan of php lottery, ask the boss to make suggestions.
when I was writing a lottery, I encountered a problem. Because I have to modify the amount of the user winning the lottery first, then record the log, and modify the record, if one of them fails, join the queue and continue to execute. It is obviously n...

Redis mysql php cache

Mar.10,2021
Please tell me whether it is correct to use try in php in this way.
when writing a lottery, when opening a lottery, the winning information is stored in redis, and then the following code is written to call it. Please check whether it is used correctly . public function giveOutGoldFoins() { $object = new...

Redis mysql php

Mar.10,2021
The probability that the website returns 502 from 3: 20 a.m. to 3: 40 a.m. every day is more than 2 / 1000. The server load is not high, on the contrary, all indicators have decreased?
...

Load-balancing redis mysql nginx php

Mar.29,2021
Questions about performance tuning
background: a set of app keys , fixed dividends and my assets . Each user can only create a maximum of 5 pairs of keys. Each user can participate in a fixed dividend (a current deposit similar to Yu e Bao). My assets need to return the values of t...

Redis mysql cache linux php

Apr.01,2021
How to ensure both performance and data consistency in the case of concurrency by judging the result after query and then operating the data?
< H2 > problem description < H2 > each user s record in the order table of the database has 15 states ( 12 status codes represent on-the-way status, 3 status codes represent final status ). The state between data can be transferred. requires tha...

Redis mysql java

Apr.11,2021
Efficient coupon (send and use) technology selection and solution
problem description recently, we need to build a high-speed coupon distribution system. Now the mysql, used in the database has a sub-database and sub-table, but it has a bottleneck on the sending rate, and it is more complex for batch operations (the...

Mongodb redis mysql

May.10,2021
Spring source code depth analysis: Aop implementations are JdkDynamicAopProxy and CglibAopProxy, respectively.
there is the following code in the invoke method: Get the interception chain for this method. List<Object> chain = this.advised.getInterceptorsAndDynamicInterceptionAdvice(method, targetClass); the above method finally calls t...

Redis mysql tomcat spring java

May.22,2021
How Laravel operates multiple databases
problem description the project requires programs to connect to multiple databases (about 30, with the same username and password, but different library names). How to operate gracefully in Laravel? reference I have looked up the article Laravel ...

Redis mysql linux laravel php

Oct.13,2021
Optimization scheme of label screening
as shown in figure this kind of tag filtering can be done directly by sql if it is taken directly from the database, but it is not ideal. If the listing of each tag has a list of Redis, for example: the list of area (Chaoyang District)-1 235,456, ...

Filter algorithm redis mysql php

Nov.05,2021
What kind of database to use relational algebra
recently, I m going to take relational algebra; that is, database principles; my first contact is an abstract sql statement (I don t know if that s right). now I d like to ask, what kind of database should the relational algebra of this way of writ...

Nosql oracle mongodb redis mysql

Apr.20,2022
How to import large quantities of Excel data into MySQL accurately and quickly after being deduplicated?
problem description customer table users has the following fields: there are 5 sales groups. Each sales group imports at least one batch of 100000 items of data into the table every month, and can only import the data of its own sales group ...

Redis mysql php

Jun.30,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3c28b-2c2fc.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3c28b-2c2fc.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?