MySQL on Windows - Good Idea?

mikeballer asks: "We currently run our website from a shared hosting environment, with ASP and MS SQL Server. We will be moving to a dedicated host, and to save money, we are considering transitioning to MySQL while remaining in a Windows environment. I had read the Windows-vs-Unix section of the MYSQL documentation, but what is Slashdot's perspective on the performance of MySQL in a Windows environment?"

Comments

Avoided

[hords]

We had bad luck with a Windows NT server hosting about 50 websites and running MySQL databases. It was slower than pulling out of Iraq! Man that Pentium 150 processor was smokin!

Ok, bad example. Haven't tried it since, lol. (Hey, it ran ok on a simular linux server!)

There is a SQL Server Solution

[Chabil Ha']

Depending on how big your database is, SQL Server 2005 Express Edition may be a 'free' alternative. While there is nothing wrong with switching to MySQL ( I mean hey, this is /., if I didn't give OSS a plug, well... ), if you want to stay with MS technology, while not having to pay for the DBMS, then this might fit the bill. The only drawback with this solution is that you're basically limited to a 4GB database. Try it out, you might like it.