Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 10 of 10
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    Iran
    Posts
    695
    Thanks
    0
    Thanked 0 Times in 0 Posts

    The merits/demerits of using MSSql instead of mySql!

    I know that it's not such a wise question, but my host is letting me use MSSql or mySql, whatever I like. I'm trying to find out which one is better? I mean I never felt that I need anything more than mySql, but what are the benefits of using MSSql instead of mySql? Would I ever need that? I have a basic understang of both of them and I know that MSSql is much bigger, I mean it has lots of rules and stuff in comparision with mySql, but then would I really need it?

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    MySQL goes better with PHP as PHP has many native functions built in for MySQL. msSQL goes better with ASP for the same reasons.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    Mega-ultimate member
    Join Date
    Jun 2002
    Location
    Winona, MN - The land of 10,000 lakes
    Posts
    1,855
    Thanks
    1
    Thanked 45 Times in 42 Posts
    Actually, php does have some pretty nice mssql functionality built in as well. I'm currently working on a migration project going from php / mysql -> php / mssql. The syntax is virtually identical. mysql_fetch_assoc -> mssql_fetch_assoc.

    The only difference is the SQL syntax

    NOW() (in mysql) goes to {fun NOW()} in mssql

    I've noticed no performance changes so far.

  • #4
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Originally posted by Spookster
    MySQL goes better with PHP as PHP has many native functions built in for MySQL. msSQL goes better with ASP for the same reasons.
    This is confusing to me. You have about 30 native mssql functions http://be2.php.net/mssql in PHP, but for ASP, i don't even know one or never heard of a specific mssql function.

    But ASP and MsSQL frequently are combined because they are used in an all windows environment. http://www.codingforums.com/showthre...light=msserver


    ConfusedOfLive : Maybe switch host. If you need a PHP-MySQL host, then why pick a windows host ? It will probably even be more expensive ...

  • #5
    Senior Coder
    Join Date
    Jun 2002
    Location
    paris, france
    Posts
    1,216
    Thanks
    0
    Thanked 0 Times in 0 Posts
    http://www.devshed.com has a good article on outgrowing mySQL

    also
    http://vulcanus.its.tudelft.nl/~acm/got/antimysql.php

    for an article on mySQL's flaws
    photoshop too expensive? use the GIMP! www.gimp.org

  • #6
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    I was grouping ADO in with ASP. Probably should have explained that.

    Regardless though as was pointed out, which is a better point than what I was trying to make, is that mySQL almost always comes bundled with PHP on linux hosting just as msSQL comes bundled with ASP on windows hosting.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #7
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Originally posted by whackaxe
    http://www.devshed.com has a good article on outgrowing mySQL

    also
    http://vulcanus.its.tudelft.nl/~acm/got/antimysql.php

    for an article on mySQL's flaws
    I didn't find that article in the first link. Here's a usefull article about db's if you have outgrown MySQL.
    http://www.sitepoint.com/article/554/
    It's actually strange the PostGreSQL isn't more popular and more frequently used.
    http://www.postgresql.org/

  • #8
    Senior Coder
    Join Date
    Jun 2002
    Location
    paris, france
    Posts
    1,216
    Thanks
    0
    Thanked 0 Times in 0 Posts
    oops, sorry, 'twas sitepoint actually. my bad
    photoshop too expensive? use the GIMP! www.gimp.org

  • #9
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,096
    Thanks
    11
    Thanked 101 Times in 99 Posts
    MSSQL is a fine database (its basically an MSified version of Sybase) and is mostly far superior to MySQL though it would not be as fast as MySQL on simple SELECTS etc (90% of a web-applications job) it is however a true RDBMS.

    The problem is that is has to live on a windows platform with all the stability and security issues that that brings , thats enough IMO to say 'no thanks'.

    Note though that in Raf's other thread about producing 'smart tags ' , if you had MSSQL (or sybase/oracle etc) you could handle all of the str_replace()ment of keywords to links within the database itself which is much faster than a later str_{preg}_replace later on.


    Raf its not strange that postgreSQL is not as popular as it should be (as its a fine DB), being for a long while the only decent open source database, it treated anyone but uber::geeks like trash , it still can't manage a decent windows port , and it seems more interested in selling t-shirts (with the poxy elephant) than anything else , it alientated too many people for too long , it will (!IMO!) be a while before anyone gives them another go
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #10
    Regular Coder
    Join Date
    Jul 2002
    Location
    Iran
    Posts
    695
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Well, thanks for your nice answers! Actually MSSql is optional on my hosting, and I have MySQL by default, so, I don't need to change my hosting! But then mySql is installed on a different server and for connecting to it I have to enter an IP as for my host, it means I can't use "localhost" anymore, but I have to write an IP.

    Thanks for those addresses too, and I think finally firepages answered me: I won't use MSSql!!


  •  

    Posting Permissions

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