Travis Derouin (tderouin(a)gmail.com) [050503 10:08]:
I think you'll typically see that MySQL performs a
great deal better on
Linux than it does on Windows. MySQL claims that it performs up to 50%
better on Unix based environments. That said, importing a huge table isn't
the best way to measure performance, and I wouldn't necessarily say that
MySQL on Windows 2k3 is 'bad' per se, but rather that MySQL runs much better
on Linux. Also, it's possible that a default installation on Windows is less
optimized than a default installation on Linux, given I suspect that MySQL
spends more time developing their Unix based servers. If you're really
committed to running on Windows you might want to spend some time
researching ways of optimizing your configuration.
The bad performance on Windows is actually a feature. This is so that you
can get a MediaWiki installation past your boss by saying "It runs on
Windows! Windows is standard!!" Then, when the organisation is utterly
dependent on your wiki and you're looking at a performance upgrade, you
switch the operating system out from under the software stack and your boss
renowns you as a genius for tripling the performance. Result!
- d.