Analysis of Indexing and Query Optimization Implementation on MySQL Database to Improve the Performance of Pamulang University Student Attendance Application
Keywords:
MySQL Indexing, Query Optimization, Attendance System, Database Performance, Information Systems, PHP, Pamulang UniversityAbstract
At Pamulang University, student attendance is recorded through two mechanisms: the online My Unpam platform and
traditional paper-based sheets. In practice, the offline method is still more commonly used due to unstable campus
network connectivity, resulting in delays of 10–15 minutes at the beginning of each class. This study examines how the
use of indexing and query optimization in MySQL can enhance the performance of a web-based attendance system,
allowing the online method to operate more efficiently and reliably. The research framework includes a situational
analysis involving lecturers and Information Systems students, followed by simulated testing using 30 dummy student
records. Optimization techniques such as creating indexes on NIM and date fields and evaluating queries with EXPLAIN
are applied within a PHP-based prototype. The outcomes include an improved PHP-MySQL attendance prototype and
instructor guidelines to support system adoption. This work aims to reduce dependence on manual attendance practices
and strengthen digital transformation initiatives in higher education by improving database responsiveness and overall
system performance.
References
Anwar, C. (n.d.). Application of Academic Information System With Extreme Programming Method (Case Study: Jakarta International Polytechnic).
Anwar, C. (2024). Rekomendasi Teknis Untuk Pengolahan Data Berbasis Web. Jurnal Informatika Utama, 2(1), 50–54. https://doi.org/10.55903/jitu.v2i1.166
Hasibuan, L. H., Munaji, A. A., Deolika, A., Chitayae, N., & Setiawan, E. (2022). Student Attendance Information System Using QR Code (Quick
Response) At ITSNU Kalimantan. JURNAL SISFOTEK GLOBAL, 12(2), https://doi.org/10.38101/sisfotek.v12i2.548
Ikhsan, M., & Helmina, H. (2024). Design of a Web-Based Lecturer Attendance Information System Using QR Codes at Muhammadiyah University of Jambi. Brilliance: Research of Artificial Intelligence, 4(1), 94–99. https://doi.org/10.47709/brilliance.v4i1.3838
Karimah, M., Sita Eriana, E., & Haerudin, H. (2024). Spectrum: IMPLEMENTASI Multidisciplinary METODE Journal EXTREME PROGRAMMING PADA PEMBUATAN E TICKETING BERBASIS WEB (Vol. 1, Issue 2).
Khafid, M. A., Fithri, D. L., & Latifah, N. (2025). Photo Integration of Attendance System with Geolocation and Features for Counseling Recommendations Based on TOPSIS Method at MA Salafiyah Ahmad https://doi.org/10.24176/insytech.v1i2.14518
Komunikasi, D., Siswa, U., Siswi, /, Masyarakat, D., Di, U., Nusantara Bojonggede, S., Anwar, C., & Sunardi, D. (n.d.). Pelatihan Pengembangan Ide Bisnis Inovatif Berbasis Teknologi Informasi.
Maesaroh, S., Gunawan, H., Lestari, A., Tsaurie, M. S. A., & Fauji, M. (2022). Query Optimization in MySQL Database Using Index. In International Journal of Cyber and IT Service Management (IJCITSM) (Vol. 2, Issue 2). https://iiast journal.org/ijcitsm/index.php/IJCITSM/article/view/84
Melani Putri, N., Amirul Mu, M., & Faaza Naafia, S. (2025). Development of a Web-Based Rolling and Attendance System for News Coverage Employees at the Communication and Information Office (Kominfo) of Bima City. In Indonesian Applied Research Computing and Informatics (Vol. 1, Issue 1). https://doi.org/xx.xxxxx/iarcixxxhttps://jurnal.tdinus.com/index.php/iarci
Muzakir, A. (2025). Digital Transformation of Student Attendance: Backend Design Based on IoT Technology with RFID. In JOURNAL OF INFORMATION SYSTEM & ARTIFICIAL INTELLIGENCE n JISAI (Vol. 6, Issue 2).
Nusa Jauhari, F., & Hermawan, A. (2023). Implementation of Student Activity Attendance System using Photo and Location Detection based on Android General Terms. In International Journal of Computer Applications (Vol. 185, Issue 48).
Rozali, C., Zein, A., & Eriana, E. S. (2024). Artificial Intelligence (AI) Dimasa Depan : Tantangan Dan Peluang. Jurnal Informatika Utama, 2(1), 66–71. https://doi.org/10.55903/jitu.v2i1.177
Zein, A., & Sita Eriana, E. (n.d.). Perencanaan Dashboard Untuk Monitoring Kinerja Dosen Menggunakan Metode Noetix dan Rasmussen Pada Fakultas Ilmu Komputer Universitas Pamulang.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Aldy Bifal Pratama, Muhammad Naufal Skha Yusfa, Ahyat Musyawwa (Penulis)
This work is licensed under a Creative Commons Attribution 4.0 International License.
Creative Commons Attribution 4.0 International (CC BY 4.0).
This work is licensed under a 