Main Article Content
Database is a collection of data that forming an information that useful for managers in an organization to facilitate data management process to become more effective and safely guarantee. A good database has fast and accurate response time performance in data execution processing. To manage the database, it requires a special language or query known as Structure Query Language (SQL). Increase need for fast information, will need a proper SQL as well. Therefore, through this research, a test analysis will be used to optimize the query response time in database management system commonly used today, namely the My Structured Query Language (MySQL) using PHP version of 7.2.27 relational database which will be tested on the Oebufu Village Aspiration and Information Service System (SELMA) that acessed from localhost panels with a total of 1000 test data records. The test is devoted to the effectiveness of using SELECT queries in calling and displaying data through restructuring the use of clauses. This study aims to help improve data management by providing the results of the comparative analysis of response times between the general query model and the optimized query results in order to determine the correct and efficient query structure. The result is proven by doing query optimization, it is found that the presentation of time optimization is significant, which is 78% much faster than the initial query, through this test it can be concluded that optimization plays an important role in streamlining the response time of database queries.
This work is licensed under a Creative Commons Attribution 4.0 International License.
The author who submits the manuscript must understand and agree that if accepted for publication, the copyright of the article belongs to JICON and Nusa Cendana University as the journal publisher. Copyright (copyright) includes the exclusive right to reproduce and provide articles in all forms and media, including reprints, photographs, microfilm and any other similar reproductions, as well as translations. The author has the right for the following:
1. reproduce all or part of published material for the author's own use as classroom teaching materials or oral presentation materials in various forums;
2. reuse part or all of the material as compilation material for the author's written work;
2. make copies of published material for distribution within the institution where the author works.
JICON and Nusa Cendana University and Editors make every effort to ensure that no data, opinion or statement is wrong or misleading to be published in this journal. The content of articles published on JICON is the sole and exclusive responsibility of their respective authors.
 O.M.I. Tavares., “Analisis dan Perancangan Layanan Aspirasi Dan Informasi Pada Kelurahan Oebufu,” Jurnal Teknologi Terpadu., vol. 5, no. 2, hal. 303–313, 2019, [Daring]. Tersedia pada: https://journal.nurulfikri.ac.id/index.php/jtt/article/download/226/157/777.
 R. Gunawan, “Pengukuran Query Respon Time pada NoSQL Database Berbasis Document Stored,” Jurnal Siliwangi., vol. 4, no. 2, hal. 100–103, 2018, [Daring]. Tersedia pada: http://jurnal.unsil.ac.id/index.php/jssainstek/article/view/609.
 M. Saputro, “Pengoptimalisasian Query Pada Study Kasus Sistem Informasi Penjualan Kue Di Toko Wien,” STMIK AKAKOM Yogyakarta, vol. 489, no. 20. eprints.akakom., Yogyakarta, hal. 313–335, 2018, [Daring]. Tersedia pada: https://eprints.akakom.ac.id/6885/.
 P. Noviyanti, A. Deolika, S. Hartinah, C. A. Haris, T. Maryana, dan N. D. Sari, “Perbandingan Query Response Time pada Model Query View dan Cross Product,” e-Jurnal JUSITI., vol. 7, no. 2, hal. 131 141, 2018, [Daring]. Tersedia pada: https://ejurnal.dipanegara.ac.id/index.php/jusiti/article/view/248.
 S. Suhartati dan Y. Dwi Atma, “Optimasi Query Sederhana Guna Kecepatan Query Pada Database Server,” Metik Journal., vol. 1, no. 1, hal. 13–17, 2017, [Daring]. Tersedia pada: http://jurnal.stmikbpn.ac.id/index.php/metik1/article/view/5.
 H. Siswanto, T. Andi, dan K. Kusrini, “Optimasi Query Pada Human Resource Information System (HRIS) di Universitas XYZ,” JMAI (Jurnal Multimedia)., Artif. Intell., vol. 2, no. 1, hal. 1–6, 2018, doi: 10.26486/jmai.v2i1.53.
 I. Wasiso, A. Nugroho, D. Yulianto, dan K. Kusrini, “Optimasi Basis Data Spasial Untuk Mengidentifikasi Lampu Apill Di Kabupaten Sleman,” RESEARCH: Computer, Information System & Technology Management., vol. 3, hal. 31, 2020, doi: 10.25273/research.v3i1.5799.
 R. Pamungkas, “Optimalisasi Query Dalam Basis Data My SQL Menggunakan Index,” RESEARCH : Computer, Information System & Technology Management., vol. 1, no. 1, hal. 27, 2018, doi: 10.25273/research.v1i1.2453.
 J. H. Lubis, “Analisa Performansi Query Pada Database Smell,” Jurnal Manajemen dan Informasi Pelita Nusantara., vol. 21, no. 1, hal. 42–49, 2017, [Daring]. Tersedia pada: http://e-jurnal.pelitanusantara.ac.id/index.php/mantik/article/view/188/105.