Essentially, there is a middle table, the two systems to read this piece of middle table, the two systems to write data, operation timing synchronization each other to write data,
This kind of situation in two tables is better, write the same table, both of us in a very short time to read and write this list will deadlock

CodePudding user response:

Please provide the table structure, as well as the table 2 system and regular homework, speaking, reading and writing SQL and execution frequency, to analysis.