Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: MYSQL vs SQLServer

    Hi
    Please, i want to know advantages and disadv. of sqlserver and mysql.
    OR
    When to use each of them?
    OR
    Which is better?
    OR
    Any thing to compare?
    Any information?

    Thanx

  2. #2
    Join Date
    Jun 2003
    Posts
    4
    Here is a basic comparison i did a while back on a mailing list. Like i mention in the comparison, neither server was optimized and simple queries which makes this a BASIC comparison. Sloppycode also did a comparison of databases which you can find http://www.sloppycode.net/benchmark. I use both database servers, it just depends on the requirements of the project.

    Hope this helps,
    Pete


    -------- Begin Comparison --------

    My Benchmark, unfortunately I did not record the time it took to load the
    records into the database, but the load time for sql server was about 3
    times slower. The records were created by using a for loop to make a list
    of 100,000 numbers hashed with the md5 algorithm, so 100,000 32 character
    strings. They were then loaded into each database server from the text file
    by using the importing features that come with each database server. I imported
    the strings until there were 8 million records in the MySQL database and only
    4 million in the SQL server database. Each query was run 3 times to eliminate
    some lag. When run in asp time difference was determined only by using Now() not
    by using a timer function so time is only expressed in whole seconds for asp,
    not 10ths or 100ths of a second. Both database servers were fresh installs
    installed just to test this so no tuning was done to either.

    System:
    P4 1.4ghz
    128 RAM
    SQL Server Ent. Eval.
    MySQL v3.23.55

    Database: Test
    Table: Temp
    Column: Col001 char(32) NOT NULL
    No Indexes on either

    DB Size (MSSQL)
    4 Million records
    334 MB after shrink

    DB Size (MySQL)
    8 million records
    251 MB

    MySQL
    Query = SELECT COUNT(*) FROM TEMP
    Command Line = 0.18 sec
    ODBC Connection w/ASP = 3.0 sec
    *Note* The 3 seconds was only the first query, after that the time was less
    than a second

    MS SQL
    Query = SELECT COUNT(*) FROM TEMP
    Query Analyzer = 10.0 sec (after 2 previous queries, first was 13 sec)
    OLEDB Connection w/ASP = 13.0 sec

    You can clearly see the speed of MySQL is much faster than MSSQL, but my
    test machine is not tuned for either database and does not have a lot of RAM
    installed, which will make the results different than the results some of
    you may get on your machines. The COUNT query done is obviously not very
    technical and MSSQL may have been faster with a more intensive query.

    -------- End Comparison --------

  3. #3
    Join Date
    Jul 2003
    Posts
    11

    Cool

    Advantages
    -------------
    MySQL is cheaper!
    MySQL is faster when using MyISAM table (no transaction support or RI)
    MySQL runs on Linux, Unix, Windows OS!

    Dis-Advantages
    ------------------
    MySQL does not support database Views.
    MySQL does not support Stored Procedures.
    MySQL does not support Triggers.
    MySQL does not support sub-queries.
    You must configure MySQL with the InnoDB storage engine if you want transaction-safe(rollback, commit, unit-of-work) tables, and referential integrity (foreign keys).
    SQL Server comes with much nicer client tools.

    SHAMELESS PLUG -
    But, you can always get nice heterogeneous database UI tools at:
    http://www.yazoosoft.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •