PERBANDINGAN KINERJA DATABASE SERVER MYSQL DAN SQL SERVER ( STUDI KASUS DATABASE SERVER POLITAMA SURAKARTA)

  • Agus Haryawan Politeknik Pratama Mulia Surakarta

Abstract

There are various kinds of database server application, including MySQL and SQL Server. Each
has advantages and disadvantages. Politama server uses SQL Server as its database server
application. Program used to access this server is created with desktop applications. Up to this time
applications can run smoothly. However, if the server is used to serve as many data requests at the
same time, servers are often slow to respond. One solution to overcome this problem is to use an
alternative database server application such as MySQL. Before it is implemented, we try to examine
the response speed between SQL Server and MySQL.
Comparisons were made using two computers with identical specifications. SQL Server and
MySQL installed on each computer. Then, an application is created to access both the database
server application. The tested instructions are SELECT, INSERT and DELETE.
The results showed that MySQL applications provide better performance on all SQL commands.
Access time to MySQL 1.85 times faster in SELECT command and 18.25 times faster at INSERT
command KRS table records. The difference of access time increase as the number of record
increase.
Keywords: database, MySQL, SQL Server, comparison

Author Biography

Agus Haryawan, Politeknik Pratama Mulia Surakarta

Dosen Jurusan Teknik Elektro, Politeknik Pratama Mulia Surakarta

Published
2018-05-30