No abstract

No abstract

No abstract

Penggunaan query pada database dengan jumlah record data transaksi yang besar tentunya membutuhkan akses sumber daya DBMS (Database management System), pada database MySQL, query yang digunakan untuk jumlah record data ribuan tentunya akan mempengaruhi kinerja database, eksekusi SQL query dengan jumlah record yang sangat banyak akan memerlukan waktu yang lama dan mempengaruhi waktu proses pengolahan data. Penggunaan perintah SQL stored procedure dapat mengoptimalkan penggunaan query terutama untuk melakukan perintah yang sering digunakan dalam manipulasi data, sehingga akan mempercepat proses, stored procedure merupakan kumpulan pernyataan Query yang disimpan pada database, untuk itu perlu dilakukan pengujian kinerja waktu eksekusi query. Penelitian ini bertujuan memberikan analisis kinerja query stored procedure pada Relational Database Management System (RDBMS) MySQL. Pada penelitian dilakukan pengujian kinerja query stored procedure dengan jumlah record data dari 50 sampai dengan 25000. Query stored procedure yang diuji menggunakan perintah SQL (Create, Select, Update, Delete) dengan kasus database transaksi belanja online. Hasil rekapitulasi pengujian kinerja query stored procedure pada MySQL menunjukkan pada pengujian query stored procedure select dan delete waktu eksekusinya berbanding lurus dengan jumlah record datanya. Sedangkan pengujian query stored procedure create dan update terjadi peningkatan waktu eksekusi yang cukup signifikan terutama pengujian dengan jumlah 25000 record data.

Senior High School 1 V Koto Timur is one of the public schools located in Padang Pariaman Regency. In solving student problems, schools have guidance and counseling teachers that are responsible for providing services to students, whether students have problems or commit violations. But in fact, the existing counseling guidance has not been properly recorded related to the guidance and violations committed by students. With the development of a counseling guidance application, it is hoped that it can be a solution to these to monitor guidance counseling or violations committed by students. This study aims to develop a counseling guidance application that can mediate interactions between teachers and students as well as monitor student progress by their parents. The counseling guidance application was developed using the waterfall method, where each stage is carried out sequentially. It was developed using the CodeIgniter 3 framework of data management, the counseling guidance application utilizes the PHP programming language, MySQL database, and Apache web server. Based on the research that has been done, it can be concluded that this counseling guidance application can be an intermediary for interaction between teachers and students, especially at SMA N 1 V Koto Timur, with an activity log that stores counseling guidance data between teachers, BK teachers, homeroom teachers, and students. In addition, parents can also monitor developments related to violations, guidance, and achievements of their children at school.