Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147

    Unanswered: SQL Server 2005 Express VS MySQL

    Hi guys,

    im trying to develop a web application that uses a backend database, however im not quite sure what db backend to use. What are the diffrence between sql server express and mysql.. which is better to use in terms of small enterprises.? what are their limits..?

    thanks you very much
    Give me a place to code and i shall move the earth!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by coleone
    What are the diffrence between sql server express and mysql..
    the SQL that they use is different

    Quote Originally Posted by coleone
    which is better to use in terms of small enterprises.?
    the one you are more familiar with

    Quote Originally Posted by coleone
    what are their limits..?
    if you think you are in any danger of even coming close to the limits (4GB for SSEE) then you should be thinking of getting the full-blown SQL Server engine

    mysql is limited only by how much disk space you have (several terabytes, if i recall correctly)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2006
    Posts
    115
    1 is FREE 1 is FREE up to its limitation.

    You shall look at the requirements until you upgrade to the next DBMS to see which suit your needs.

    I would strongly encourage SQL 2005, it's easy to use, but nothing is perfect, I have lots of work around to achieve what I want.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    The performance of either is going to be mostly dependent on your application. I can bring any RDBMS to its knees with a few well placed cartesian joins.

    Code:
    select *
    from customers, orders, order_item
    See how long that runs for on any system that has even just a couple hundred customers with orders.

  5. #5
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147
    thank you very much guys, i will go with MSSQL.

    another question was is it true that PHP will soon be charging its users in their next release..?
    Give me a place to code and i shall move the earth!

Posting Permissions

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