Performance test 2


Published 7/5/2007 10:11:07 PM  in  General ADO.NET

Test number two. Same background as here.

In the first test I was using 10 virtual clients at the same time requesting banners without delay between requests, therefore putting extreme load on the webapplication and database.

Now I instead used just one single client, requesting banners without delays between requests. And the results are so interesting:

Results (Access is norm and 100)
Access 100
MSSQL 342
MySQL no sp 257
MySQL SP 486


I think it's fair to say that MSSQL is better on handling locks that MySQL, while operating one request at a time MySQL is faster. Access didn't perform as bad now, multiple users at the same time is a known limitation of Access.