PERBANDINGAN KINERJA DATABASE SERVER MYSQL DAN SQL SERVER ( STUDI KASUS DATABASE SERVER POLITAMA SURAKARTA)
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
Keywords: database, MySQL, SQL Server, comparison
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).