J I M P - Jurnal Informatika Merdeka Pasuruan
Vol 8, No 1 (2023): MARET 2023

Analysis of Speed and Connection When Accessing Information in Database

Muhammad Guruh Ajinugroho (Gunadarma University)
Tubagus Maulana Kusuma (Gunadarma University)
Suryarini Widodo (Gunadarma University)



Article Info

Publish Date
13 Sep 2023

Abstract

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

Copyrights © 2023






Journal Info

Abbrev

informatika

Publisher

Subject

Computer Science & IT

Description

Jurnal Informatika Merdeka Pasuruan (JIMP) terbit 3 kali dalam satu tahun yaitu dibulan maret, agustus dan desember. Memuat tulisan ilmiah yang berhubungan dengan bidang teknologi informasi serta aplikasi teknik informatika. Jurnal JIMP terbitan berkala ini adalah hasil penelitian dari tugas akhir ...