Performance and Efficiency Testing Analysis of Database Systems in Academic Information Systems

Analisis Pengujian Kinerja dan Efisiensi Sistem Basis Data dalam Sistem Informasi Akademik

Abstract

This study examines the performance and efficiency of database systems within academic information systems, acknowledging the increasing demand for responsiveness and reliability in managing complex academic data. As educational institutions increasingly rely on digital systems, performance testing becomes essential to ensure that these systems continue to support the learning environment effectively. Guided by the ISO/IEC 25010 standard, the research focuses on evaluating three key aspects of performance efficiency: time behavior, resource utilization, and capacity. Using JMeter, a range of user load scenarios were simulated, and the results were examined through Control Quality Charts and Nelson Rules to detect underlying issues affecting system performance. The findings reveal that 82.5% of queries demonstrated good time behavior, and 80% performed well in resource usage. However, half of the tests related to capacity highlighted the need for further improvements. Some queries experienced delays and consumed excessive CPU and memory resources, indicating areas where optimization is required. These insights highlight the importance of refining queries and managing resources more effectively to ensure a seamless user experience. Future research should consider automated optimization, machine learning-based performance prediction, and system scalability, especially in more dynamic and distributed academic environments.