Optimize database to reduce resource confliction and deadlock by splitting table into many tables
When working with database (I'm now working with PostgreSQL), no need to mention fact that the deadlock error is one of the most problem which takes long headache time to be solved correctly.