I'm struggling to understand why they wouldn't just use non-locking selects instead of turning auto-commit off. Does the auto-commit add additional lock overhe

I'm struggling to understand why they wouldn't just use non-locking selects instead of turning auto-commit off. Does the auto-commit add additional lock overhead for some reason ?