MS SQL server and MySQL response speed comparation

Abstract

In order to select database managmeent tool (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 benchmark software, simple software to test features relevant to the system was developed. The tool was developed using the same technology as the school’s information 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 realized 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 with the justification of the applied methodology. The first step in realization of the research was to determine testing domain and investigation framework. The features and requirements of the technical environment are shown. The conceptual design and features as well as user interface and available options of the testing tool realized for the purpose of this research are described. Finally the results and conclusions are presented.