Re: SQL Servers Vs mySQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Todd Burry (tburry_at_nospam.com)
Date: 04/14/04 

Date: Tue, 13 Apr 2004 21:18:02 -0700

It is my understanding that if you use the MyISAM table type with MySQL
that it performs faster than SQL Server and is pretty much the fastest
database server out there. Both databases are reliable, but do note that
the MyISAM table type does not offer transactional support. If you use
one of the other table types with MySQL then you will get performance
more on par with SQL Server.

MySQL does not as of yet offer stored procedure support which may be of
concern to you, but if you do look into MySQL I recommend you look into
GROUP_CONCAT, REPLACE, and LIMIT which are statements not supported by
SQL Server, but are very useful.

Hope this helps a bit even though I don't have any site comparisons.

Relevant Pages

  • Re: SQL server vs mySQL ???
    ... The easiest way to support multiple databases is to work with a data access ... This question changes depending on which version of MySQL one has. ... * SQL Server has richer trigger support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL server vs mySQL ???
    ... SQL Server has the broadest range of tools and support utilities of any database system on the planet--by far. ... MS SQL versus MySQL? ... As of 5.0, MySQL finally supports stored procedures, so they are very similar there (you can genericize your data access a bit due to sprocs in both). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why SQL Server over MySQL
    ... MySQL did not support any kind of atomic transactions ... Even then it's not a robust transaction processing ... you'd get in a mature product like SQL Server. ...
    (microsoft.public.sqlserver.server)
  • RE: Transfer LARGE DB from MySQL to SQL Server 2K5 problems
    ... newsgroups are managed (and making that a selling point for MSDN ... forums, which, needless to say, drives me away from the MS web sites, and is ... I am going through the MySQL ODBC v3.51 driver, ... streaming across the wire to my SQL Server box. ...
    (microsoft.public.sqlserver.dts)
  • Re: Using Mysql or SQL server as backend to Access front end
    ... Postgres is not compared ... The feature set of MySQL compared here is from five years ago ... Enterprise then the larger database products become a problem ... businesses will never need Oracle 10g, SQL Server or Postgres. ...
    (comp.databases.ms-access)