Nuansa Informatika
Vol. 19 No. 2 (2025): Nuansa Informatika 19.2 Juli 2025

Performance and Efficiency Testing Analysis of Database Systems in Academic Information Systems: Analisis Pengujian Kinerja dan Efisiensi Sistem Basis Data dalam Sistem Informasi Akademik

Kusuma Dewi, Utami (Unknown)
Lingga Wicaksono, Ryan (Unknown)
Dwifebri Purbolaksono, Mahendra (Unknown)
Satria, Villy (Unknown)



Article Info

Publish Date
10 Jul 2025

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.

Copyrights © 2025






Journal Info

Abbrev

ilkom

Publisher

Subject

Computer Science & IT

Description

NUANSA INFORMATIKA adalah jurnal peer-review tentang Informasi dan Teknologi yang mencakup semua cabang IT dan sub-disiplin termasuk Algoritma, desain sistem, jaringan, game, IoT, rekayasa Perangkat Lunak, aplikasi Seluler, dan ...