Performance Comparison of Object-Relational Mapping (ORM) and SQL Query in Developing the Booking Service API at PT Tunas Dwipa Matra

Abstract

In this digital era, information technology plays a pivotal role across various industries, particularly in the service and reservation sector, where companies like PT Tunas Dwipa Matra are compelled to adopt advanced tools to remain competitive and enhance customer experiences. A critical component of this transformation is the use of Application Programming Interfaces (APIs), which enable seamless communication between systems and improve operational efficiency. A key decision in system design revolves around choosing between Object Relational Mapping (ORM) and SQL queries for database management. ORM simplifies development processes and enhances maintainability, making it well-suited for routine tasks and scenarios where ease of use and security are priorities. On the other hand, SQL queries excel in handling complex, performance-critical operations, offering greater control and faster execution for specialized or large-scale tasks. Performance testing highlights a trade-off between the two approaches: ORM tends to be slower in execution but more memory-efficient, while SQL delivers faster query processing at the cost of higher memory consumption. By strategically leveraging the strengths of both ORM and SQL, PT Tunas Dwipa Matra can optimize system performance, scalability, and maintainability, ultimately ensuring high-quality service delivery and improved customer satisfaction.