Newton : Networking And Information Technology
Vol. 3 No. 1 (2023): June

Optimization of Queries on Databases by Using the Ingres Algorithm

Nudin, Nur lhsan (Unknown)
Sifaunajah, Agus (Unknown)
Arifin, Muhyiddin Zainul (Unknown)



Article Info

Publish Date
27 Jul 2023

Abstract

Bahrul Ulum Islamic Boarding School is the oldest cottage in Jombang district which was founded in 1830 AD until now. which of course has a very large number of students, both students and alumni status. The author wishes to research how to manage data in information systems with hundreds or millions of data quickly and easily. Proper query design is very influential on information system applications, if you only rely on conventional query techniques, the results needed to process queries are relatively slow, and the time required is also longer. The purpose of this research is to optimize the query using the ingress algorithm which will later be tested and compared the results with queries that have not been optimized or conventional to determine the extent to which the query process can be accelerated. The experimental results show that the execution time is more effective and faster using an optimized command using the Ingres algorithm with an average processing time of 0.13226 seconds, and an average request that has not been optimized 0.2079 seconds, in other words the result is 65% faster than unoptimized queries.

Copyrights © 2023






Journal Info

Abbrev

newton

Publisher

Subject

Computer Science & IT

Description

NEWTON: Networking and Information Technology is a scientific journal published by the Institute for Research and Community Service (LPPM), KH University. A. Wahab Hasbullah Jombang. The aims of the journal are to publish and disseminate high quality, original research papers and article review in ...