Analysis of Speed and Connection When Accessing Information in Database

Muhammad Guruh Ajinugroho, Tubagus Maulana Kusuma, Suryarini Widodo


Animality Vetama is a pet store and clinic that has implemented an integrated management system which consist of several interconnected applications and a database across branches. Several branches complained about performances. Several factors was analyzed by the developer, resulting in a hypothesized that the problem was caused by connectivity issues on specific internet provider dubbed “provider X”. Said problem is suspected to lies within the TCP port because it only occurs when accessing the system but not when doing other things like browsing. Client application connects to the database using MySQL direct connection. To prove this case, a study using purposive sampling quota approach was proposed to determine what makes a problematic provider. This approach was then followed by a simulation for each criteria by doing a test connection to the database using the existing method and a proposed method using webservice. The simulation were focused on average connection durations as well as success and failed ratio. The result shown that in general, connecting to the database using webservice is a lot time faster than connecting client directly regardless of the provider. The success ratio is also increased significantly


web service; connection; internet provider; purposive sampling quota; troubleshooting; information system analysis and design; software engineering

Full Text:



Aakanksha, B. Jain, D. Saxena, D. Sahni, and P. Sharma, “Analysis of hypertext transfer protocol and its variants,” Advances in Intelligent Systems and Computing, vol. 670, pp. 171–188, 2019, doi: 10.1007/978-981-10-8971-8_17/COVER.

MySQL, “MySQL :: MySQL 8.0 Reference Manual :: 4.2.7 Connection Transport Protocols.” [Online]. Available:

MySQL, “MySQL :: MySQL 8.0 Reference Manual :: 4.2.4 Connecting to the MySQL Server Using Command Options.” [Online]. Available:

INSPIRASIBIZ, “Akses Program dari Internet Menggunakan koneksi Indihome Fiber,” INSPIRASIBIZ, 2017. [Online]. Available:

A. Setiawan, “Layanan Indihome yang Kurang Bersahabat bagi Developer — Arif Setiawan,” Personal Blog, Jan. 2017. [Online]. Available:

APJII, “Daftar Anggota Penyelenggara Jasa Internet Indonesia (APJII).” [Online]. Available:

A. J. Wood, M. Graham, V. Lehdonvirta, and I. Hjorth, “Good Gig, Bad Gig: Autonomy and Algorithmic Control in the Global Gig Economy,” Work, Employment and Society, vol. 33, no. 1, pp. 56–75, 2019, doi: 10.1177/0950017018785616.

S. I. Fannani, M. Najib, and M. Sarma, “THE EFFECT OF SOCIAL MEDIA TOWARD ORGANIC FOOD LITERACY AND PURCHASE INTENTION WITH AISAS MODEL,” Jurnal Manajemen & Agribisnis, vol. 17, no. 3, pp. 285–285, Nov. 2020, doi: 10.17358/JMA.17.3.285.

S. Campbell et al., “Purposive sampling: complex or simple? Research case examples:,”, vol. 25, no. 8, pp. 652–661, Jun. 2020, doi: 10.1177/1744987120927206.

M. A. P. Bahinting et al., “Stronger than the Internet Connectivity: A Phenomenology,” Jul. 2022, doi: 10.5281/ZENODO.6791820.

A. Tondak, “A Beginner’s Guide to SQL Commands: DDL, DML, DCL, & TCL,” Microsoft Azure Data Engineer Certification [DP-203] & Q/A, 2022. [Online]. Available:

F. Halili and E. Ramadani, “Web Services: A Comparison of Soap and Rest Services,” Mod Appl Sci, vol. 12, no. 3, p. 175, Feb. 2018, doi: 10.5539/mas.v12n3p175.

H. F. Herdiyatmoko and Y. D. Pratama, “IMPLEMENTASI RESTFUL SERVER MENGGUNAKAN LIBRARY CHRISKACERGUIS CODEIGNITER 3,” Seminar Nasional Informatika (SEMNASIF), vol. 1, no. 1, pp. 1–7, Dec. 2020, [Online]. Available:

K. Larkin, S. Gordon, G. Gordon, and R. Nowak, “Make HTTP requests using IHttpClientFactory in ASP.NET Core | Microsoft Docs,” 2022. [Online]. Available:

C. Kacerguis, “CodeIgniter RestServer,” Github, 2019. [Online]. Available:

AnyDesk, “About Us – AnyDesk,” 2022. [Online]. Available:

Martin, “Integration with PuTTY :: WinSCP,” WinSCP, 2022. [Online]. Available:

Postman, “Postman API Platform,” 2022. [Online]. Available:


Copyright (c) 2023 Muhammad Guruh Ajinugroho, Tubagus Maulana Kusuma, Suryarini Widodo

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