MySQL on a Windows Machine 1

[BlueBeep]

I'm curious to know if anyone has any idea how MySQL goes with ASP (or any other language) on a Windows machine, production wise. Our website contains static pages and we're planning on making them dynamic. Cost is an issue. If anyone knows how well MySQL performs on WinNT or knows of issues I should be concerned about, I'd appreciate hearing from you.

I've already had experience with MySQL on a Linux environment and wondering if its Windows brother is on the same level. I know MySQL doesn't compare with SQL Server or Oracle when it comes to features, but it's something we're willing to give up because of cost.

 

[likelylad]

Hi

I have only ever used MySQL on Windows PC's and have never found it a problem. Speed wise I have never found speed to be a problem with it, some of the tables I have are over 1.2 million records.

What language to use, when I asked that question in this forum, the resounding advice was to use PHP and I must say that it was a decision I didn't regret. First of all its free, the support from the PHP forum is excellent and has helped me solve every problem I have encountered. PHP also comes with the MySQL libaries (and many more!!!!) installed.

If you go to

http://www.foxserv.net/portal.php

you will find the program to install Apache/PHP/MySQL in one easy installation and everything integrated.

Hope this helps you

 

[BlueBeep]

Thanks for the response. What kind of web site did you run? Was it commercial? I'm really concerned how much load it can handle. What version of Windows? NT/2000? A lot of our developers come from the Microsoft world, so we would develop the application a lot faster if it was made in ASP. Another reason is that we already have ASP code from an intranet app that we can apply to the web site.

 

[likelylad]

The Version of Windows I used was Windows 2000 Server.
The Web stuff is for Production based information systems, at any one time there would be normally about 80 simultaneous users. MySQL can handle up to approx 100 simultaneous users.
In relation to ASP talking to MySQL, I'm afraid I can't help you there