A Performance Analysis of the Dbms - MYSQL Vs POSTGRESQL
A Performance Analysis of the Dbms - MYSQL Vs POSTGRESQL
Author(s): Svetlana Andjelic, Slobodan Obradović, Branislav GacesaSubject(s): Business Economy / Management, Communication studies, ICT Information and Communications Technologies
Published by: Žilinská univerzita v Žilině
Keywords: open source DBMS; MySQL; PostgreSQL; ACID;
Summary/Abstract: Modern communications among business subjects imply an exchange of a lot of data and information. To enhance that process in all its aspects, electronic data storing and processing is mandatory and enabled by an application of a DBMS (Date Base Managment System). This paper shows the performances analysis of the two most popular open source DBMSs - MySQL and PostgreSQL. First, some characteristics of these DBMSs are shortly described. Then the applied procedure of the performed testing is described. That is, the query (select, insert, delete and order by) execution times were measured for the both DBMSs mentioned, and the results shown in tabular and graphical forms. The goal of this paper is to make the choice of an adequate DBMS easier for future users.
Journal: Komunikácie - vedecké listy Žilinskej univerzity v Žiline
- Issue Year: 10/2008
- Issue No: 4
- Page Range: 53-57
- Page Count: 5
- Language: English