KEUNTUNGAN PENGGUNAAN EXTERNAL FUNCTION PADA DATABASE POSTGRESQL

• Main Author: Nahrun Hartono
• Format: Article
• Language: Indonesian
• Published: LPPM Universitas Potensi Utama 2015-02-01
• Series: CSRID Journal
• Subjects: INSERT; External Function
• Online Access: http://csrid.potensi-utama.ac.id/ojs/index.php/CSRID/article/view/64

Database id a central data for an information system, there were many database system applications that revolve both paid and free. PostgreSQL is one of the free database system and it has the powerful feature, one of the feature that make it different with others sysem is a function features, where the users can make their function by them selves by using spesific programming language, then it can be called return for executed. In this research the writer tries for conducting additional data testing by using INSERT Query and External Function Query on the terminal/command prompt and web browser. From the result of the trial, the research found that the average of time in additional data processing on the terminal/command prompt by using INSERT Query was 185.293 ms and the average of time External Function Query proccess was 129.52 ms, while the average of time in additional data processing on web browser by using INSERT Query was 168.363 ms and External Function Query was 145.64 ms. There was a difference both of the query, but the important thing and should be noted that external function is a command was defined by stand alone by the user, this matter lets the user to determine a specify command that they need.