1. Re: MySQL performance [was: odbc resources]
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
