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

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.

Creator

Abednego Dwi Septiadi1 , Lee jeong-bae2

Date

2020

Contributor

peri irawan

Format

pdf

Language

english

Type

text

Files

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.