Comparing the Performance of ORMs

Jakkapan Attala; Chaiyaporn Khemapatpapan

doi:10.14456/jcct.2025.16

Authors

Jakkapan Attala Student, Program in Computer Engineering, College of Engineering and Technology, Dhurakij Pundit University, Bangkok 10210, Thailand
Chaiyaporn Khemapatpapan Assistant Professor, Dr., Program in Computer Engineering, College of Engineering and Technology, Dhurakij Pundit University, Bangkok 10210, Thailand

DOI:

https://doi.org/10.14456/jcct.2025.16

Keywords:

Object-Relational Mapping, Prisma, TypeORM, Sequelize, Performance Evaluation

Abstract

Modern application development requires efficient data access, and Object-Relational Mapping (ORM) tools simplify SQL operations by enabling developers to interact with databases using object-oriented paradigms. This study compares the performance of three widely used ORMs Prisma, TypeORM, and Sequelize when used with PostgreSQL in a Docker-based TypeScript environment. The experiments involved four types of table relationships: Single Table, One-to-One, One-to-Many, and Many-to-Many. Performance was evaluated based on response time, memory usage, and CPU utilization. The findings suggest that no single ORM outperforms the others in every aspect, as each tool has distinct advantages and limitations depending on the use case. This study aims to provide developers with insights into selecting the most appropriate ORM for their projects, thereby enhancing the efficiency of database management in modern application development.

Downloads

Download data is not yet available.

References

Attala, J. (2025). Comparing-Performance-ORM-typescript-with-PostgreSQL [Dockerfile]. https://github.com/Jakkapan-a/Comparing-Performance-ORM-typescript-with-PostgreSQL.

Chen, T.-H., Shang, W., Jiang, Z. M., Hassan, A. E., Nasser, M., & Flora, P. (2016). Finding and Evaluating the Performance Impact of Redundant Data Access for Applications that are Developed Using Object-Relational Mapping Frameworks. IEEE Transactions on Software Engineering, 42(12), 1148-1161. https://doi.org/10.1109/TSE.2016.2553039.

Güvercin, A. E., & Avenoglu, B. (2022). Performance Analysis of Object-Relational Mapping (ORM) Tools in .Net 6 Environment. Bilişim Teknolojileri Dergisi, 15(4), 453–465. https://doi.org/10.17671/gazibtd.1059516.

Marchuk, Y., Dyyak, I., & Makar, I. (2023, September 26-28). Performance Analysis of Database Access: Comparison of Direct Connection, ORM, REST API and GraphQL Approaches. 2023 IEEE 13th International Conference on Electronics and Information Technologies, 174–176. https://doi.org/10.1109/ELIT61488.2023.10310748.

Monster Connect. (n.d.). Relational Database. https://monsterconnect.co.th/relational-database. (In Thai)

Node.js. (n.d.). Process. https://nodejs.org/api/process.html?utm_source=chatgpt.com.

Prisma. (n.d.a). Introspection for PostgreSQL in a TypeScript Project. https://www.prisma.io/docs/getting-started/setup-prisma/add-to-existing-project/relational-databases/introspection-typescript-postgresql.

Prisma. (n.d.b). Type Safety. https://www.prisma.io/docs/orm/prisma-client/type-safety.

Renovate. (2025). Model Basics. Sequelize. https://sequelize.org/docs/v6/core-concepts/model-basics.

TypeORM. (n.d.). Entities. https://typeorm.io/docs/entity/entities.

Vaja, D. D., & Rahevar, M. (2016, December 19-21). Improve Performance of ORM Caching Using In-Memory Caching. 2016 International Conference on Computing, Analytics and Security Trends, 112-115. https://doi.org/10.1109/CAST.2016.7914950.

Zaytsev, S. (2025). Architecture. https://jestjs.io/docs/architecture.