Not sure what you mean by "the database holds locks for the minimum time needed." Locks are always held until the transaction commits.