A performance analysis of the DBMS - MySQL vs PostgreSQL

被引：0

作者：

Andjelic, Svetlana ^{[1
]}

Obradovic, Slobodan ^{[2
]}

Gacesa, Branislav ^{[3
]}

机构：

[1] Railway College of Vocational Studies, Belgrade

[2] Megatrend University, Belgrade

[3] Telekom. Srpske A. D., SRJ Internet Srpske, Banja Luka

来源：

Communications - Scientific Letters of the University of Žilina | 2008年 / 10卷 / 04期

关键词：

ACID; MySQL; Open source DBMS; PostgreSQL;

D O I：

10.26552/com.c.2008.4.53-57

中图分类号：

学科分类号：

摘要：

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.

引用

页码：53 / 57

页数：4

共 50 条

[41] Concentration of pectin solution: Forward osmosis performance and fouling analysis
Andrzejewski, Adam
Krajewska, Martyna
Nowak-Grzebyta, Jagoda
Szczygielda, Mateusz
Stachowska, Ewa
Prochaska, Krystyna
JOURNAL OF MEMBRANE SCIENCE, 2022, 653
[42] Water splitting vs. sulfite oxidation: An assessment of photoelectrochemical performance of TiO2 nanotubes modified by CdS/CdSe nanoparticles
Ahmed, Rasin
Xu, Yin
Zangari, Giovanni
ELECTROCHIMICA ACTA, 2018, 259 : 1095 - 1103
[43] Evaluation of the performance and emission and spectroscopic analysis of an improved soy methyl ester
Hasnain, S. M. Mozammil
Sharma, R. P.
RSC ADVANCES, 2019, 9 (46) : 26880 - 26893
[44] HIGH-PERFORMANCE LIQUID CHROMATOGRAPHY ANALYSIS OF LOMOFUNGIN IN STREPTOMYCES LOMONDENSIS
Li, Shan
Ye, Qiuming
Wang, Wei
Hu, Hongbo
Zhang, Xuehong
JOURNAL OF LIQUID CHROMATOGRAPHY & RELATED TECHNOLOGIES, 2013, 36 (15) : 2059 - 2068
[45] Efficient Query Analysis and Performance Evaluation of the Nosql Data Store for BigData
Gupta, Sangeeta
Narsimha, G.
PROCEEDINGS OF THE FIRST INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND INFORMATICS, ICCII 2016, 2017, 507 : 549 - 558
[46] Performance Analysis of .NET Based Object-Relational Mapping Frameworks
Gruca, Aleksandra
Podsiadlo, Przemyslaw
BEYOND DATABASES, ARCHITECTURES AND STRUCTURES, BDAS 2014, 2014, 424 : 40 - 49
[47] Analysis of formose sugar and formaldehyde by high-performance liquid chromatography
Iqbal, Md. Zafar
Novalin, Senad
JOURNAL OF CHROMATOGRAPHY A, 2009, 1216 (26) : 5116 - 5121
[48] Highly selective polybenzoxazinoneimide vs. its nonselective prepolymer in separation of water-ethanol mixture: Role of sorption parameters in pervaporation performance
Pulyalina, Alexandra
Goikhman, Mikhail
Podeshvo, Irina
Faykov, Ilya
Polotskaya, Galina
SEPARATION SCIENCE AND TECHNOLOGY, 2022, 57 (07) : 1139 - 1150
[49] Vitamin A Kinetics in Neonatal Rats vs. Adult Rats: Comparisons from Model-Based Compartmental Analysis
Tan, Libo
Green, Michael H.
Ross, A. Catharine
JOURNAL OF NUTRITION, 2015, 145 (03) : 403 - 410
[50] Removal of Quebracho and Tara tannins in fungal bioreactors: Performance and biofilm stability analysis
Spennati, F.
Mora, M.
Tigini, V.
La China, S.
Di Gregorio, S.
Gabriel, D.
Munz, G.
JOURNAL OF ENVIRONMENTAL MANAGEMENT, 2019, 231 : 137 - 145

← 1 2 3 4 5 →