MS SQL Server and MySQL Response Speed Comparation

Abstract

In order to select optimal database managmeent tools (i.e. DBMS) for information system developed for Valjevo Business School, testing of two available options (i.e. MS SQL and MySQL) was performed. Instead of using available banchmark software, simple software to test features relevant for the system has been developed. The tool was developed using the same technology as the scool’s system and was designed to test only relevant features. The aim was not to provide general evaluation of the tested DBMS’ but to evaluate specific features and to determine option more relevant for the specific situation and environment. This paper describes applied methodology and displays realised results. In the first part of the paper, the technical and organizational foundation is described. Then there is a description of possible solutions to the problem and applied methodology is justified. The first step in realization of the research was to determine testing domain and investigation framework. The features and requirements of the technical environment were given. The conceptual design and features as well as user interface and available options of the the testing tool realized for the purpose of this  research were described. Finally, the outcoming results are presented and the final conclusion was drawn.