MS SQL |vs| My SQL

Discussion in 'Databases' started by FCM, Nov 3, 2009.

  1. #1
    Please note that money is not an object in this matter.

    I want to compare the two based on experience and features.

    The particular version of MS that I am referring to is the 2005 version of MSSQL, and the most up-to-date version of MySQL.

    Speed difference in processing any amount of records.
     
    FCM, Nov 3, 2009 IP
  2. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Search the acrhives, this has been answered hundreds of time.
    Aside from that your question is too broad so you will only get broad answers which won't really help you.

    The only use case requirement you specify is money is not relevant, then go for the DB that has the features YOUR USE CASE NEEDS.
    Which is typically unique and can't be compared to others.
     
    chisara, Nov 3, 2009 IP
  3. FCM

    FCM Well-Known Member

    Messages:
    669
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    155
    #3
    Yeah your right. I just found a post similar to this one but it wasn't what I was looking for.

    I need to be able to process roughly 10 - 25 million queries a day.

    But I will see.

    Thanks
     
    FCM, Nov 3, 2009 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    That would be no problem with either assuming the hardware is decent.

    It's not extremely difficult to get a single server MySQL database up to about 2000 per second, which would equate to 7.2M per hour. It will also be heavily dependent on whether your queries are reads or writes.

    In either case the load is high enough that it will most likely take a decent dedicated server. Also, if the database server is separate from the application server, you may run into bandwidth limitations. Another thing to consider.
     
    jestep, Nov 3, 2009 IP
  5. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #5
    What you are looking for?
    What sort of queries you want to process? Are these FULLTEXT searches, simple index based searches or complex queries invloving multiple tables of GBs in size? How big DB you are going to host?
    The work around to this limitation is to connect application server and DB server with private LAN.
     
    mwasif, Nov 3, 2009 IP