How well do ASP.NET and MySQL work together?

Question

What have your experiences been with asp.net and mysql?

Is it actually faster than mssql in terms of connection times etc? Or is the library slower?

Is it suitable for a large scale type app?

Answer 1

There is no problem .

12 million websites around the world using MYSQL .There is no problem for using it for a big application.

Have a look on http://blog.sqlauthority.com/2009/09/09/sql-server-difference-between-sql-server-express-and-mysql/

list of MYSQL customers

Answer 2

The answers to these questions are very subjective, and you may need to determine which is best for your needs.

The best approach, I believe, is to use unit testing to get a measure of how fast connections are, for example.

So, you have a test that is able to be used on both connection functions, and you can start to compare times.

How suitable will really depend on your needs, so, if you have the application requirements spelled out, then you can look and see which will best meet your needs.

MySQL is used in many large websites, and if you are using connection pooling then connection times don't matter, and for a very busy website a connection pool may be your best bet.