|
Comparing the Performance of ORMs |
|---|---|
| รหัสดีโอไอ | |
| Creator | Jakkapan Attala |
| Title | Comparing the Performance of ORMs |
| Contributor | Chaiyaporn Khemapatpapan |
| Publisher | Department of Computer Education, Faculty of Science and Technology, Surindra Rajabhat University |
| Publication Year | 2568 |
| Journal Title | Journal of Computer and Creative Technology |
| Journal Vol. | 3 |
| Journal No. | 2 |
| Page no. | 201-213 |
| Keyword | Object-Relational Mapping, Prisma, TypeORM, Sequelize, Performance Evaluation |
| URL Website | https://so13.tci-thaijo.org/index.php/jcct |
| Website title | Journal of Computer and Creative Technology |
| ISSN | ISSN 2985-1580 (Print);ISSN 2985-1599 (Online) |
| 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. |
