Comparative Analysis of Database Query Storage Performance
Between Stored Procedure and Function
Dublin Core
Title
Comparative Analysis of Database Query Storage Performance
Between Stored Procedure and Function
Between Stored Procedure and Function
Subject
DMBS; Stored Procedure; Function; Query.
Description
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.
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.
Creator
Abednego Dwi Septiadi1 , Lee jeong-bae2
Date
2020
Contributor
peri irawan
Format
pdf
Language
english
Type
text
Files
Collection
Citation
Abednego Dwi Septiadi1 , Lee jeong-bae2, “Comparative Analysis of Database Query Storage Performance
Between Stored Procedure and Function,” Repository Horizon University Indonesia, accessed June 6, 2025, https://repository.horizon.ac.id/items/show/9219.
Between Stored Procedure and Function,” Repository Horizon University Indonesia, accessed June 6, 2025, https://repository.horizon.ac.id/items/show/9219.