Jeff I get that, but I don’t understand why simple read SELECTS need to lock at all. I mean, maybe if that database was storing my bank account balance, in which case transactional orders are hugely important.
Because the selected data could be usefull later during the transaction. It’s why you don’t use transaction if you don’t care about your selected data.