Re: fix "Deadlock found when trying to get lock; try restarting transaction"

[morteza ir]

>> But i cant do it all the time in real world
>Sure you can. What language are your programming this in?
Php and asp.net. mysql.
Do there is a way to solve the deadLock?.
If DeadLock is unavoidable, How can i restart transaction?

> I'm surprised that changing that did not help
:) you right i test again. 15 sec decrease to 12 sec. its very good for huge DB.

>This can be costly. What is it trying to do? Can be it written some other way? How many rows in tb_ID_of_BookRandomly?
The tb_ID_of_BookRandomly is temporary table and it have about 3 rows of book that i selected it before randomly.

Best.