ANALISIS PERFORMANSI QUERY MYSQL MENGGUNAKAN QUERY BUILDER PADA FRAMEWORK CODEIGNITER 4

Authors

  • Zuhar Musliyana
  • Ayu Helinda

DOI:

https://doi.org/10.33143/jics.Vol8.Iss1.2132

Abstract

Abstrak— Saat ini kebutuhan akan penggunaan database terus meningkat seiring dengan perkembangan teknologi informasi. Diantara platform database yang paling banyak digunakan saat ini adalah MySQL. Database MySQL menawarkan berbagai kemudahan untuk menangani penyimpanan data dengan jenis yang beragam. Selain itu, database MySQL juga bersifat open source sehingga memilki banyak pengembang dan mempunyai jumlah pengguna yang banyak jika dibandingkan dengan platform lainnya. Pada implementasinya database MySQL dapat dikelola secara mudah menggunakan Application Programming Interface (API) melalui berbagai jenis bahasa pemograman salah satunya yaitu PHP. Codeigniter merupakan salah satu jenis framework yang ditulis dengan bahasa pemrograman PHP. Pada tahun 2020 Codeigniter versi 4 dirilis sebagai lanjutan dari versi sebelumnya. Pada rilis versi ini, codeigniter menawarkan berbagai library yang dibutuhkan developer untuk memudahkan pengembangan aplikasi berbasis web. Salah satunya adalah library untuk mengakses database MySQL. Library berisi kumpulan query builder yang dapat digunakan untuk menjalakan query MySQL dengan ringkas. Penelitian ini difokuskan untuk melakukan analisis dan pengujian performansi query builder MySQL pada Codeigniter 4. Pengujian dilakukan dengan mengamati parameter Execution Time (ET) dari tiap transaksi insert, update dan delete pada MySQL. Hasil pengujian menunjukkan nilai rata-rata terendah dengan sample data terbesar yakni 100.000 record didapatkan pada transaksi insert dengan nilai ET 288.19 ms sedangkan nilai rata-rata tertinggi yakni pada transaksi delete dengan nilai ET 1,300 ms. Hasil penelitian ini dapat dijadikan referensi bagi pengguna framework codeigniter 4 untuk keperluan transaksi data dalam jumlah tertentu.

Kata kunci: Performansi query, codeigniter, query builder, PHP

Abstract— Currently the use of databases continues to increase along with the development of information technology. One of the most widely used database platforms today is MySQL. MySQL databases offer a variety of conveniences for handling various types of data storage. In addition, the MySQL database is also open source so it has many developers and has a large number of users when compared to other platforms. The use MySQL database can be managed easily using the Application Programming Interface (API) through various types of programming languages, one of which is PHP. CodeIgniter is a type of framework written in the PHP programming language. In 2020 codeigniter version 4 was released as a continuation of the previous version. In this release, codeigniter offers various libraries that developers need to make it easier to develop web-based applications. One of them is a library to access MySQL databases. The library contains a collection of query builders that can be used to run MySQL queries concisely. This research is focused on analyzing and testing the performance of MySQL query builder on Codeigniter 4. The simulation is carried out by observing the Execution Time (ET) parameter of insert, update and delete transaction in MySQL. The test results show that the lowest average value with the largest data sample is 100,000 records obtained in insert transactions with an ET value of 288.19 ms while the highest average value is in delete transactions with an ET value of 1,300 ms. The results of this study can be used as a reference for those who will use the CodeIgniter 4 framework for the purposes of data transactions in a certain amount.

Keyword: Query performance, codeigniter, query builder, PHP

References

A. Helinda, Z. Musliyana, D. R. Y. Tb, M. Dwipayana, J. Suanda, and A. N. Johari, “Performance analysis of heterogeneous database management system (DBMS) synchronization using message digest 5,†in AIP Conference Proceedings, 2020, vol. 2291, doi: 10.1063/5.0027970.

D. Mysql, “MySQL Connectors,†2022, [Online]. Available: https://dev.mysql.com/doc/connectors/en/connectors-apis.html.

wiki, “CodeIgniter,†2022, [Online]. Available: https://en.wikipedia.org/wiki/CodeIgniter.

Hadyan Palupi, “Apa Yang baru Di CodeIgniter 4,†2021, [Online]. Available: https://codepolitan.com/blog/apa-yang-baru-di-codeigniter-4.

I. WARMAN and R. RAMDANIANSYAH, “ANALISIS PERBANDINGAN KINERJA QUERY DATABASE MANAGEMENT SYSTEM (DBMS) ANTARA MySQL 5.7.16 DAN MARIADB 10.1,†J. TEKNOIF, vol. 6, no. 1, 2018, doi: 10.21063/jtif.2018.v6.1.32-41.

W3Tech, “Usage of server-side programming languages for websites,†W3Tech Web Technology Surveys, 2022. https://w3techs.com/technologies/overview/programming_language/all.

Z. Musliyana, A. G. Satira, M. Dwipayana, and A. Helinda, “Integrated Email Management System Based Google Application Programming Interface Using OAuth 2.0 Authorization Protocol,†Elkawnie, vol. 6, no. 1, 2020, doi: 10.22373/ekw.v6i1.5545.

Downloads

Issue

Vol. 8 No. 1 (2022): APRIL 2022

Section

Articles

License

COPYRIGHT TRANSFER FORM

The copyright to this article is transferred to Universitas Ubudiyah Indonesia (UUI) if and when the article is accepted for publication. The undersigned hereby transfers any and all rights in and to the paper including without limitation all copyrights to UUI. The undersigned hereby represents and warrants that the paper is original and that he/she is the author of the paper, except for material that is clearly identified as to its original source, with permission notices from the copyright owners where required. The undersigned represents that he/she has the power and authority to make and execute this assignment.

We declare that:

  1. This paper has not been published in the same form elsewhere.
  2. It will not be submitted anywhere else for publication prior to acceptance/rejection by this Journal.
  3. A copyright permission is obtained for materials published elsewhere and which require this permission for reproduction.

Furthermore, I/We hereby transfer the unlimited rights of publication of the above mentioned paper in whole to UUI. The copyright transfer covers the right to reproduce and distribute the article, including reprints, translations, photographic reproductions, microform, electronic form (offline, online) or any other reproductions of similar nature. The corresponding author signs for and accepts responsibility for releasing this material on behalf of any and all co-authors. After submission of this agreement signed by the corresponding author, changes of authorship or in the order of the authors listed will not be accepted.

Retained Rights/Terms and Conditions

  1. Authors retain all proprietary rights in any process, procedure, or article of manufacture described in the work.
  2. Authors may reproduce or authorize others to reproduce the work or derivative works for the author’s personal use or for company use, provided that the source and the UUI copyright notice are indicated, the copies are not used in any way that implies UUI endorsement of a product or service of any employer, and the copies themselves are not offered for sale.
  3. Although authors are permitted to re-use all or portions of the work in other works, this does not include granting third-party requests for reprinting, republishing, or other types of re-use.