Impact of transaction isolation levels on application performance in database systems

In this paper we have analysed the impact of running transactions at different isolation levels on application performance, more specifically on the execution time of the set of transactions. Three scenarios of transaction executions were defined, based on real applicative cases, and applied to different transaction sets and transaction isolation levels. Tests were performed using three actual DBMS: Oracle, Microsoft SQL Server and MySQL.