Doing a project in the process of maintenance, found that the table data, will be different users to view and modify; A deadlock.
This project can't use a thread to do now, in addition to optimize execution efficiency, set up after the foreign key index, for example, are there any other deal?
Trouble you to provide some advice or information, to learn, thank you!

CodePudding user response:

Select * from XXX for update lock users frequently operating table only the current lock commit or rollback transaction this table will be released