Comparative Performance Analysis of MySQL and SQL Server Relational Database Management Systems in Windows Environment

Abstract

Abstract:The enormous amount of data flow has made Relation Database Management System the most important and popular tools for persistence of data. While open-source RDBMS systems are not as widely used as proprietary systems like Oracle DB or SQL Server, but over the years, systems like MySQL have gained massive popularity. In a stereotypical view, SQL Server is considered to be an enterprise-level tool, MySQL has carved a niche as a backend for website development. This paper is an attempt to set a benchmark in comparing the performance of MySQL against SQL Server in Windows Environment. To test and evaluate the performance the Resort Management System named Repose is considered. The result shows that SQL Server is still a significantly better performer when compared to MySQL.

Analisis Sumber Daya Teknologi Informasi dan Komunikasi untuk Sistem Pembelajaran Daring

“…Namun semua responden yang mengimplementasikan Moodle menggunakan RDBMS MySQL. MySQL adalah RBMS open source yang menjadi default dari LMS Moodle sekaligus sebagai database yang paling populer (Saikia et al, 2015).…”

Analisis Kinerja Web Server pada SIM Manajemen Diklat Poltekpel Sorong Menggunakan RDBMS MySQL dan MariaDB

“…Namun untuk PostgreSQL, variasi waktu respons rata-rata dari web server ini lebih stabil. Penelitian (Saikia et al, 2015) melakukan analisis terhadap kinerja MySQL dan SQL Server dengan melihat waktu yang dibutuhkan saat menanggapi permintaan. Hasil menunjukkan bahwa SQL Server menunjukkan kinerja yang lebih baik dibanding MySQL dalam hal waktu respons.…”

PsiDB: A Framework for Batched Query Processing and Optimization

“…As a result, our workloads all consist of a heterogeneous set of queries with different join skeletons (Table 6.1). Note that there are up to eight tables joined in the same query in TPC-H. To reveal the advantages of PsiDB, we compare it with Microsoft SQL Server 13.0, which is believed to deliver excellent performance in processing a wide range of workloads [53], and the open-source MySQL 8.0. To ensure a fair comparison with baselines, we turned on the data cache and query plan cache, and also built indexes for all attributes involved in any selection condition in the queries.…”