Performance, efficiency, and automation in academic report generation with Dapper: An approach applied to university systems

Abstract

The purpose of this study was to optimise performance in the generation of academic reports within the Research Management System of the Universidad Nacional de Chimborazo (UNACH) through the incorporation of Dapper as a micro-ORM. The research was conducted using a quantitative, non-experimental and applied approach, following a procedure that included requirements analysis, the design of a REST architecture, the implementation of SQL queries using Dapper, module deployment, and performance evaluation in accordance with the quality criteria established by the ISO/IEC 25010 standard. Load tests were carried out with Apache JMeter at concurrency levels of 4, 10, 50 and 100 users, assessing temporal behaviour, resource utilisation and system capacity. The results showed response times of under 15 seconds with 100% compliance, efficient resource usage (CPU 31.25%; RAM between 63% and 70%; disk 6.75%), and a processing capacity of 0.83 requests per second, equivalent to 83% compliance. The study concludes that the integration of Dapper significantly increased the efficiency, stability and speed of the reporting module, confirming its suitability as a high-performance solution for academic systems requiring intensive data management. It is also identified as a viable alternative for implementation in other institutional modules that demand agile and efficient processes.