Optimasi Query Sistem Informasi Menggunakan Stored Procedure
Keywords:
Optimization, Query, Information System, Stored ProcedureAbstract
Queries are used for operations on information systems that use a database as data storage. The importance of queries should be a major concern at the application design stage. Generally the application designer ignores it so applications that are made will have poor performance when the data in the database is getting bigger. To overcome the decline in application performance because of neglecting query design, query optimization is performed. This study provides a solution to the declining performance of information systems by optimizing query information systems using stores procedures. The database in this study is designed by using MySQL Server 5 with 12 tables. The store procedure chosen in this study is function. There are 13 functions created with 12 functions for each table and 1 function to capture the status of the database operation processes.
Downloads
Published
Issue
Section
License
Authors who publish with this journal agree to the following terms:
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
