I have a simple application.This application update data of a table (B) from another table(A) which is changed every 60 sec. User may read data at any time so creating deadlock. How is this sort of problem solved in real world. Considering maximum 100 users how could I avoid deadlock. How would web application handling thousand of request avoid deadlock?
Select Query : Select * from tableB Update Query : update table tableB set tableB.someCOl = tableA.someCol where tableA.col1 = tableB.col3