Re: MySQL performance [was: odbc resources]
- Posted by Craig Welch <craig at cwelch.org> Sep 30, 2006
- 722 views
Craig Welch wrote: > I've run a million updates, and all seems fine, including the final > cleanup. > Running 5 million updates runs well, with speeds between 800 and 1,800 > transactions per second. > > That's not too shabby at all! I don't think I need to test this aspect > of ODBC/SQL any further ... > That was written last year, with Microsoft's SQL Server. I've just installed MySQL, which I need for another application. I ran the same benchmark against it, and rather than the 1,000 transactions per second realised with SQL Server, MySQL delivers around 15! -- Craig