Eliminating deadlocks by making queries not apply for shared locks has an immediate effect.

Disadvantages:

1, dirty reads

2. Only shared lock (S lock) participation can be resolved

3, need to modify the statement itself to use