IJIIS: International Journal of Informatics and Information Systems
Vol 3, No 2: September 2020

Comparative Analysis of Database Query Storage Performance Between Stored Procedure and Function

Abednego Dwi Septiadi (Amikom Purwokerto University, Indonesia)
Lee Jeong Bae (Sun Moon University, South Korea)



Article Info

Publish Date
30 Sep 2020

Abstract

This research was conducted to measure the data storage time carried out by the DBMS on data that has been prepared with an increasing number of data, the data provided is consistent student data which will be stored with Stored Procedure and Function. This study uses the action research method which has 4 stages, starting with planning, action, observation and reflection. From the results of the experiments that have been carried out, it appears that Stored Procedure is able to outperform Function in data storage time. The data provided are 2 different types of data, each of which consists of 500, 2500, 4500 and 6500 data stages. This study also compares data storage that is differentiated by the computer between the data provider computer and the data storage computer or server, the result of which is the Stored Procedure. able to outperform Function in data storage speed.

Copyrights © 2020






Journal Info

Abbrev

IJIIS

Publisher

Subject

Computer Science & IT

Description

The IJIIS is an international journal that aims to encourage comprehensive, multi-specialty informatics and information systems. The Journal publishes original research articles and review articles. It is an open access journal, with free access for each visitor (ijiis.org/index.php/IJIIS/); ...