#1
  1. No Profile Picture
    Uneducated Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    34
    Rep Power
    13

    ASP.NET + MySQL - Any reason not to?


    Beginning development on a new project, we are currently deciding which technologies to use. For various reasons, we have pretty much decided to use Windows/IIS/C# over Linux/Apache/PHP, but are currently reviewing our database options. We are seriously considering MySQL (running on a Linux server) for cost-saving reasons, but do not want to sacrifice functionality or stability.

    Is there any reason not to use a MySQL back-end with a .NET application?

    Thanks
    The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us. -Bill Watterson
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,453
    Rep Power
    4539
    You'll only have the mysql drivers to use, unlike sql server where you have a native driver in addition to odbc. You can run mysql on your windows computer if you want. My former windows hosting company had php/mysql/mssql/asp/NET available on their servers so you could use whatever technology you wanted.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester
  4. #3
  5. No Profile Picture
    Uneducated Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    34
    Rep Power
    13
    Is the MySQL Connector/Net driver not native? I understand that we can run MySQL on the Windows server itself, but this is a large application - the database will need to be on its own servers.
    The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us. -Bill Watterson
  6. #4
  7. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,453
    Rep Power
    4539
    I don't know much about connector/NET, except it's from mysql, not microsoft, hence not a native driver like the mssql client driver that's included in the NET framework.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester
  8. #5
  9. No Profile Picture
    Uneducated Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    34
    Rep Power
    13
    Not native in the sense that it is a non-Microsoft component, but it is not ODBC either. It is actually written in C# and supposedly much faster than using the ODBC driver. The question is how its performance will compare with MS SQL.
    The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us. -Bill Watterson
  10. #6
  11. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,453
    Rep Power
    4539
    I'm sure there must be some performance comparison studies posted somewhere, and I suspect there are load testing applications for both mssql and mysql available. In any case this isn't really IIS related, you'll probably find a more complete answer in a mysql related forum or site.

    If you want a guess, in general mssql will slightly outperform mysql, and the ms sql drivers are probably a skosh faster than the mysql drivers.
    ======
    Doug G
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester

IMN logo majestic logo threadwatch logo seochat tools logo