I have a questions about this.

My thinking is that in large systems transaction on db can cause performance issue. And one of solution is coming to my mind is.

User unitOfWork to apply all changes as we need. Use Optimistic concurrency locks on aggregates

Is it a good idea ? I am thinking that in that way we will keep data consistency and resolve performance issue of transactions