Högskolan i Skövde

As the complexity of Pure-SQL queries continues to increase, the impact they have on the readability and maintainability of code also continues to increase. Object Relational Mapping (ORM) offers a means of abstracting the SQL queries, turning them into more easily handled objects. The main drawback of ORMs is the performance impact from the addition of an abstraction layer to transform ORM objects into SQL queries for interactions with a server. The study aims to measure the impact of two ORM libraries, Prisma and Sequelize, with Pure-SQL as a baseline using the metrics of response time and memory usage through a quasi-experiment. 

The response time results show that while generally close, as expected Pure-SQL has the lowest response time across all query operations and is statistically different from both Prisma and Sequelize. Memory usage results also show that Pure-SQL is the most memory efficient and is also statistically different from Prisma and Sequelize.