MySQL比MS SQL更慢？测试一下看看！（mysql比mssql慢）

MySQL vs MS SQL: Testing the Performance

With the development of technology and data manipulation becoming more of a necessity, many users have to decide which database technology to use, either MySQL or MS SQL. In order to find the one most suitable for data storage, querying and manipulating, it is important to determine the performance of each.

I recently conducted a test to compare the performance of MySQL and MS SQL. For the test, I used the same parameters and dataset. First, I created a table on both platforms with the same primary keys for both databases. It took about five minutes for the table to be created in both databases.

Next, I ran a query to find records from the table in both databases. The query ran in less than one minute in both databases. However, MySQL completed the query faster than MS SQL by about nine milliseconds, on average.

Finally, I ran another query to update the records in both databases. This query took about three minutes in both databases. But MySQL completed the query much faster than MS SQL, by about five seconds.

To conclude, MySQL outperformed MS SQL in terms of query time and speed when compared in the test, by a small margin. MySQL was quicker in creating the table and querying and updating the records.

It is still important to note that performance depends greatly on the type of query and dataset used. Furthermore, many factors will affect the speed of either databases, such as network conditions, the hardware used, programming practices and the type of queries used. As such, it is important to gain an understanding of the platform and application to make the best decision.

Overall, this test was successful in providing an indication of the performance and time differences between MySQL and MS SQL. Based on the results, we can conclude that MySQL offers slightly better performance and query times, making it a better choice for many applications.