Optimization of Web-Based Printing Order Management System Using Redis Database for Efficient Data Handling

Authors

  • Pita Mellati Universitas Dian Nuswantoro
  • Galuh Wilujeng Saraswati Universitas Dian Nuswantoro
  • Wildan Mahmud Universitas Dian Nuswantoro
  • Erba Lutfina Universitas Dian Nuswantoro, Indonesia
  • Resha Meiranadi Caturkusuma

DOI:

10.33395/sinkron.v10i1.15502

Keywords:

Agile Scrum, Load Testing, MySQL, Ordering System, Redis

Abstract

The rapid advancement of information technology has encouraged small and medium-sized enterprises to shift from manual operational procedures to structured digital systems. However, many small printing businesses continue to face delays, data inconsistencies, and limited real-time monitoring due to conventional order management practices. These challenges highlight the need for a more responsive and efficient ordering system capable of improving transaction accuracy and service delivery speed. This study addresses the issue by developing a web-based ordering system using an iterative Agile Scrum approach, followed by a comprehensive performance evaluation through simulated concurrent user testing. The results show a substantial improvement in system responsiveness, with user data retrieval time decreasing from 11,228 ms to 2,148 ms (an 80.9% improvement) and order processing time reduced from 16,954 ms to 4,697 ms (a 72.3% improvement), resulting in an overall average efficiency gain of 76.6%. The integration of Redis caching significantly enhances system performance, stability, and load distribution, addressing the current gap in Redis implementation for small-scale printing environments. This study demonstrates that adopting a hybrid data-handling architecture can provide a scalable, reliable, and high-performance solution for digital ordering processes, enabling small enterprises to improve operational efficiency and customer satisfaction.

GS Cited Analysis

Downloads

Download data is not yet available.

References

Alami, A., & Krancher, O. (2022). How Scrum adds value to achieving software quality? Empirical Software Engineering, 27(7). https://doi.org/10.1007/s10664-022-10208-4

Aldi, F. (2022). Web-Based New Student Admission Information System Using Waterfall Method. Sinkron, 7(1), 111–119. https://doi.org/10.33395/sinkron.v7i1.11242

Alfatich Mulia, I., Agung Prasetyo, A., & Nugroho, A. (2022). APLIKASI PERUMAHAN DIGITAL RAKYAT INDONESIA SEBAGAI SOLUSI PENATAAN PERUMAHAN YANG MODERN DENGAN METODE AGILE. Jurnal SIMETRIS, 13(1).

Ali, A. H. (2024). Innovative Strategies for Enhancing Web Application Performance: A Contemporary Load Testing Approach. International Journal of Engineering Trends and Technology, 72(10), 246–256. https://doi.org/10.14445/22315381/IJETT-V72I10P124

Arafat, M., Trimarsiah, Y., Susantho, H., & Redaksi, D. (2022). INFORMATIKA DAN TEKNOLOGI (INTECH) Rancang Bangun Sistem Informasi Pemesanan Online Percetakan Sriwijaya Multi Grafika Berbasis Website INFORMASI ARTIKEL A B S T R A K. JURNAL INTECH, 3(2), 6–11.

Durmic, N. (2024). Adopting Agile With Scrum by Outsourced Project Teams: A Case of Bosnia and Herzegovina. TEM Journal, 13(4), 2955–2968. https://doi.org/10.18421/TEM134-30

Fernando Mulia, & Brigita Meylianti Sulungbudi. (2019). PEMANFAATAN TEKNOLOGI DIGITAL PADA UMKM (STUDI PENGGUNAAN INTERNET PADA PPKM KABUPATEN BANDUNG). Journal of Accounting and Business Studies, 4(2), 3–4.

Firdaus, J. E., & Prayudi, Y. (2024). PENGEMBANGAN BACKEND MEDIA SOSIAL DENGAN MENGGUNAKAN METODE SCRUM. EDUSAINTEK: Jurnal Pendidikan, Sains Dan Teknologi, 11(2), 416–430. https://doi.org/10.47668/edusaintek.v11i2.1020

Gyorödi, C., Gyorödi, R., & Sotoc, R. (2015). A Comparative Study of Relational and Non-Relational Database Models in a Web- Based Application. International Journal of Advanced Computer Science and Applications, 6(11). https://doi.org/10.14569/ijacsa.2015.061111

Hartanto, Mb., Muhammad Fawa, T., & Eko Hendro, D. P. (2023). ANALISA KINERJA DATABASE DAN IMPLEMENTASI CACHE REDIS PADA WEB SERVICE LUMEN. In Jurnal Alih Teknologi Komputer (ALTEK) (Vol. 4, Issue 2). https://lumen.laravel.com/,https://github.com/laravel/lumen,https://laravel.com/docs

Hendrawati Hamid, & Chandra Putra Kusniadi. (2024). The Influence of Digital Marketing on the Development of MSMEs in Manado City Sulawesi Utara. Indonesian Journal of Advanced Research, 3(6), 189–198. https://doi.org/10.55927/ijar.v3i6.9800

Indrianto. (2023). PERFORMANCE TESTING ON WEB INFORMATION SYSTEM USING APACHE JMETER AND BLAZEMETER. Jurnal Ilmiah Ilmu Terapan Universitas Jambi, 7(2), 138–149. https://doi.org/10.22437/jiituj.v7i2.28440

Kanthed, S. (2023). Redis vs. Memcached in Microservices Architectures: Caching Strategies. International Journal of Multidisciplinary Research and Growth Evaluation., 4(3), 1084–1091. https://doi.org/10.54660/.ijmrge.2023.4.3.1084-1091

Kaptosv, L. (2025). Using Redis for Caching Optimization in High-Traffic Web Applications. International Journal of Advanced Multidisciplinary Research and Studies, 5(4), 1714–1722. https://doi.org/10.62225/2583049x.2025.5.4.4839

Khlamov, S., Mendielieva, M., Vovk, O., & Deineko, Z. (2025). Comparative Analysis of Jmeter and Postman for API-Based Performance Testing.

Lukas, E. N., Hasudungan, A., & Lukas, N. (2023). 241-The Impact of the Digital Divide on MSMEs’ Productivity in Indonesia. International Research Journal of Business Studies |, 16(03), 45. https://doi.org/10.21632/irjbs

Mumtahana, H. A. (2022). Optimization of Transaction Database Design with MySQL and MongoDB. SinkrOn, 7(3), 883–890. https://doi.org/10.33395/sinkron.v7i3.11528

Nur Ramadhan, I., & Saraswati, G. (2024). Penerapan Database Redis Sebagai Optimalisasi Pemrosesan Kueri Data Pengguna Aplikasi SIRESMA Berbasis Laravel. Technomedia Journal, 8(3), 64–77. https://doi.org/10.33050/tmj.v8i3.2152

Prioritizing People and Planet as the Metrics for Responsible AI Ethically Aligned Design for Business. (n.d.). https://www.weforum.org/reports/

Privalov, M. V., & Stupina, M. V. (2023). Improving web-oriented information systems efficiency using Redis caching mechanisms. Indonesian Journal of Electrical Engineering and Computer Science, 33(3), 1667–1675. https://doi.org/10.11591/ijeecs.v33.i3.pp1667-1675

Rizqi Khusnul Khotimah, D. (2021). Economic Growth and E-Commerce: Potensial for Digitizing SMSEs in East Java. East Java Economic Journal, 5(2), 45–53. https://doi.org/10.53572/ejavec.v5i2.69

Rokmana, S. P., Fiati, R., & Nindyasari, R. (2021). IMPLEMENTASI SISTEM PENJUALAN MOBIL BERBASIS WEBSITE PADA DEALER MOBIL DAFA JAYA. Jurnal SIMETRIS, 12(1).

Salunke, S. V., & Ouda, A. (2024). A Performance Benchmark for the PostgreSQL and MySQL Databases. In Future Internet (Vol. 16, Issue 10). Multidisciplinary Digital Publishing Institute (MDPI). https://doi.org/10.3390/fi16100382

Sharma, Y., & Sharma, Y. (2020). CASE STUDY OF TRADITIONAL RDBMS AND NOSQL DATABASE SYSTEM. International Journal of Research -GRANTHAALAYAH, 7(7), 351–359. https://doi.org/10.29121/granthaalayah.v7.i7.2019.777

Shi, L., & Hongming Qiao. (2024). Research and Application of Distributed Cache Based on Redis. Journal of Software, 1–8. https://doi.org/10.17706/jsw.19.1.1-8

Suryawan, A. I., & Muliantara, A. (2024). Database Performance Optimization using Lazy Loading with Redis on Online Marketplace Website. Jurnal Elektornik Ilmu Komputer Udayana, 12(3), 2–5.

Suyuti, A. D., & Khotimah, T. (2021). SISTEM APLIKASI SLIP PENARIKAN DANA OPERASIONAL DESA DI KANTOR KECAMATAN BAE KUDUS. Jurnal SIMETRIS, 12(2).

Taipalus, T. (2023). Database management system performance comparisons: A systematic literature review. https://doi.org/10.48550/arXiv.2301.01095

Taleb, Y., McGehee, K., Yan, N., Wang, S., Müller, S. C., & Samuels, A. (2024). Amazon MemoryDB: A Fast and Durable Memory-First Cloud Database. Proceedings of the ACM SIGMOD International Conference on Management of Data, 309–320. https://doi.org/10.1145/3626246.3653380

Utami, M., Zen, B. P., & Rauna, Y. S. (2021). Developing a legal assistant website “Notoaturan” using Waterfall method. SinkrOn, 5(2), 229–238. https://doi.org/10.33395/sinkron.v5i2.10902

Uzzaman, A., Jim, M. M. I., Nishat, N., & Nahar, J. (2024). OPTIMIZING SQL DATABASES FORBIG DATA WORKLOADS: TECHNIQUES AND BEST PRACTICES. ACADEMIC JOURNAL ON BUSINESS ADMINISTRATION, INNOVATION & SUSTAINABILITY, 4(3), 15–29. https://doi.org/10.69593/ajbais.v4i3.78

Zulfa, M. I., Fadli, A., & Wardhana, A. W. (2020). Application caching strategy based on in-memory using Redis server to accelerate relational data access. Jurnal Teknologi Dan Sistem Komputer, 8(2), 157–163. https://doi.org/10.14710/jtsiskom.8.2.2020.157-163

Downloads


Crossmark Updates

How to Cite

Mellati, P. ., Galuh Wilujeng Saraswati, Wildan Mahmud, Lutfina, E. ., & Resha Meiranadi Caturkusuma. (2026). Optimization of Web-Based Printing Order Management System Using Redis Database for Efficient Data Handling. Sinkron : Jurnal Dan Penelitian Teknik Informatika, 10(1), 220-231. https://doi.org/10.33395/sinkron.v10i1.15502

Issue

Vol. 10 No. 1 (2026): Article Research January 2026

Section

Articles

License

Copyright (c) 2025 Pita Mellati, Galuh Wilujeng Saraswati, Wildan Mahmud, Resha Meiranadi Caturkusuma

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Crossref
Scopus
Google Scholar
Europe PMC

Most read articles by the same author(s)