Recently had to do an investigation about MySql server performance. So what I basically did was: created a winXP wmWare image, created a script for generating populating sql; installed db server version on that machine and kept track of times while executing sql statements; reverted to the original virgin machine state; start again. The versions I tested on were MySql community server 5.1, 5.5 and the development verion of 5.6. Here is the chart that represents my findings[the smaller the better]:
Ever thought of using mysql database in .NET app? Obviously you link some other language with this DB format but it can be perfectly handled with MySql connector for .NET you can use standard ADO interfaces and approaches. Now that was the time I REALLY enjoyed working with mysql at last.
