Analisa Perbandingan Kinerja Penyimpanan Query Database Antara Stored Procedure dengan Function

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 amount of data, the data provided is consistent student data which will be stored with Stored Procedures and Functions. Stored Procedures and Functions can all be applied, but each has its own characteristics so that research needs to be done to prove who is the fastest and what kind of character is suitable for the needs and in accordance with the toilet being faced. In some cases, software developers are not precise in using the methods applied, so that problems often arise, especially the problem of less fast information presentation time. 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 Procedures are able to outperform Functions in terms of data storage time. The data provided are 2 different types of data, each of which has 500, 2500, 4500 and 6500 data stages. This study also compares data storage that distinguishes computers between data provider computers and data storage computers or servers, the result of which is Stored Procedure is able to outperform the function in data storage speed.