Can somebody please explain me why concurrent execution of transactions is desirable? I couldn't find a clear answer even though searched for hours. Thank you.
why concurrent execution of transactions is desirable
Without concurrent execution of transactions, your application throughput is limited to inverse of your transaction duration.
Eg if each transaction takes 50ms, your throughput limited to 20 transactions per second. Which means you can't perform a lot of transactions or support a large number of users.