COMPARISONAL ANALYSIS OF MYSQL AND MONGODB RESPONSE TIME QUERY PERFORMANCE
DOI:
https://doi.org/10.55606/jitek.v2i2.245Keywords:
Database, MongoDB, MySQL, Response Time, QueryAbstract
Query is the ability to display and or request data that is used to access data in the database system by using certain commands. Where a data obtained from one or more tables in the database according to what the user needs. The data can also interact with other data or tables with the aim of making it easier for the user to use it. The query response time is one of the considerations for testing databases. This journal will discuss two types of databases, namely MySQL (SQL) and MongoDB (NoSQL). Due to the increasing demand for data, data processors are competing to provide the right database with the best performance for applications or data processing. Then this journal provides a comparison analysis of MySQL and MongoDB databases in response time performance. This study uses the Query Runtime comparison execution test method between these databases. By using basic commands or DML queries, namely CRUD (Create, Read, Update, Delete). Several stages will be carried out, namely the determination of the dataset, implementation and testing, and analysis of the test results. In this study, trials were conducted on the insert, select, update, and delete processes with the data being tested were 100, 1000, 10000. After experimenting with MongoDB (NoSQL) and MySQL(SQL) databases. The MongoDB database has a faster query response time in the insert and delete process, for the query response time update and delete the MySQL database has a faster response time. Then it can be obtained that in query response time, the MongoDB database is superior in the update and delete processes with a runtime difference of 0.005 seconds and 0.017 seconds. MySQL database is superior in insert and select process with a difference of 4.137 seconds and 0.006 seconds.
References
Abdillah, L. A., Alwi, M. H., Simarmata, J., Bisyri, M., Nasrullah, N., Asmeati, A., ... & Bachtiar, E. (2020). Aplikasi Teknologi Informasi: Konsep dan Penerapan. Yayasan Kita Menulis.
Arifin, A. (2020). Migrasi dan Pemetaan Basis Data Menggunakan Pentaho Data Integration pada Portal Pengembangan dan Pembinaan Sumber Daya Manusia (PPSDM).
Astutik, I. R. I., & Rosid, M. A. (2020). Buku Ajar Basis Data Untuk Informatika. Umsida Press, 1-208.
Kadir, A. (1999). Konsep & Tuntunan Praktis Basis Data. Penerbit Andi.
Pamungkas, C. A. (2017). Pengantar dan Implementasi Basis Data. Deepublish.
Jurnal
Budiman, S., Fadhila, F., Saputro, V. A., Utami, E., & Khusnawi, K. (2021). Perbandingan Performa SQL dan NoSQL Dengan PHP Pada 5 Juta Data. IJCIT (Indonesian Journal on Computer and Information Technology), 6(1).
Faizal Anugrah Bhaswara, Riyanarto Sarno, dan Dwi Sunaryono., 2017, Perbandingan Kemampuan Database NoSQL dan SQL dalam kasus ERP Retail, Vol. 6, No.2, Departemen Informatika, Fakultas Teknologi informasi, Institut Teknologi Sepuluh Nopember(ITS).
Farozi, M. F. M. (2019). Desain Basis Data Non Relasional Nosql Mongodb Pada Website Sistem Informasi Akademik. Jurnal Sistem Informasi Komputer dan Teknologi Informasi (SISKOMTI), 1(1), 24-39.
Halimi, A., & Sudarmanto, A. (2021). ANALISIS PERBANDINGAN KINERJA WAKTU RESPON MYSQL 8.0 DAN NOSQL MONGODB MENGUNAKAN RESTAPI NODEJS PADA STUDI KASUS KELAS ONLINE. Jurnal Informatika Wicida, 10(1), 26-33.
Junaidi, A. (2017, February). Studi Perbandingan Performansi Antara MongoDB dan MySQL Dalam Lingkungan Big Data. In Annual Research Seminar (ARS) (Vol. 2, No. 1, pp. 460-465).
Olivia Maria Inacio Tavares, Sartje Mala Rangkoly, Sarah Sarah Desi Bawan, Ema Utami, Muhammad Syukri Mustafa., 2020, Analisis Perbandingan Performansi Waktu Kueri Antara MySQL PHP 7.2.27 dan NoSQL MongoDB, Vol. 4, No. 2, Magister Teknik Informatika, Universitas AMIKOM Yogyakarta, STMIK Dipanegara Makassar, Sulawesi Selatan” Jurnal Teknik Informasi.
Rivaldo Hadi Winata, Yudha Yunanto Putra., 2021, Analisis Perbandingan Performa waktu Respons Kueri Antara MySQL PHP 7.4.2, PostgreSQL, dan MongoDB, Prosiding Seminar SITASI, Program Studi Sistem Informasi, Fakultas Ilmu Komputer, UPN Veteran Jawa Timur.
Rohmat Gunawan., 2018, Pengukuran Query Respon Time Pada NoSQL Database Berbasis Document Stored, Vol. 4, No. 2, Jurusan Informatika Fakultas Teknik Universitas Siliwangi Tasikmalaya.
Tavares, O. M. I., Rangkoly, S. M., Bawan, S. B. D., Utami, E., & Mustafa, M. S. (2020). Analisis Perbandingan Performansi Waktu Respons Kueri antara MySQL PHP 7.2. 27 dan NoSQL MongoDB. JurTI (Jurnal Teknologi Informasi), 4(2), 303-313.
Warman, I., & Ramdaniansyah, R. (2018). Analisis Perbandingan Kinerja Query Database Management System (Dbms) Antara Mysql 5.7. 16 Dan Mariadb 10.1. Jurnal Teknoif ITP, 6(1), 32-41.
Watung, I. A., & Sinsuw, A. A. (2014). Perancangan sistem informasi data alumni fakultas teknik unsrat berbasis web. Jurnal Teknik Informatika, 3(1).
