Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia

Performance of a database application is dependent on many variables including network infrastructure, server hardware, client side hardware, database configuration, database design, database connectivity tools, efficiency of application coding, use of indexes and size of the database. Therefore when application performance issues arise it is often difficult to determine which aspect is the primary performance bottleneck. One of the main factor that contribute to poor database performance is due
to poorly optimized queries which fails to maintain good performance as the data volumes increases. This project is to study and fine tune the performance of student database
with a case study on Graduate Application System of Universiti Utara Malaysia. Since applications are the users' gateway to the database, poor database performance can have a huge impact on system performance. The approach used in this project for tunning the system performance is by optimizing unefficient queries. The effeciency of the query is based on the response time to output data and the cost of input/output of the query. The result of the study shows that optimized queries have a fast response time to return the data and therefore tuning query statements provide one of the most important mechanism for improving system performance.