1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

why most win web hosting provide more MySQL DB than MsSQL DB?

Discussion in 'C#' started by wacamoi, Sep 21, 2008.

  1. #1
    I check many hosting services.

    Why for the windows DB, most of them are willing to provide more MySQL DB than MsSQL DB?

    for example : a sharing windows account can provide 10 MySQL DB but why only 1 MsSQL DB.

    regards,
     
    wacamoi, Sep 21, 2008 IP
  2. yugolancer

    yugolancer Well-Known Member

    Messages:
    320
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Cuz SQL Server is extremly expensive unlike the mySQL which is open-source.
     
    yugolancer, Sep 22, 2008 IP
    wacamoi likes this.
  3. wacamoi

    wacamoi Peon

    Messages:
    810
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thank you.

    Another Question:
    MySQL DB and MsSQL DB which one is more powerful?

    regards,
     
    wacamoi, Sep 22, 2008 IP
  4. yugolancer

    yugolancer Well-Known Member

    Messages:
    320
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #4
    Well MSSQL is better, but way more expensive than mysql. In addition mssql is more advanced with views, triggers, procedures and many other things. Well i read that MySQL v5.0 supports the SP's as well so it's only matter of time when mysql will be at least as good as MSSQL.
     
    yugolancer, Sep 23, 2008 IP
  5. wacamoi

    wacamoi Peon

    Messages:
    810
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #5
    thank you again.

    Recently I set up only one table in a MSsql DB which the table is included one ( "ntext" ) data type.

    I do not know why I can only collect around 2,890 records data.

    Can a Mysql table do large storage than a MSsql table?
    That is one thing I considered which one is has more powerful storage size?

    regards,
     
    wacamoi, Sep 23, 2008 IP
  6. vihutuo

    vihutuo Well-Known Member

    Messages:
    1,511
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    180
    #6
    The number of records is only limited by how much space the web host has provided for your database
     
    vihutuo, Sep 23, 2008 IP
    wacamoi likes this.
  7. wacamoi

    wacamoi Peon

    Messages:
    810
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #7
    thank you,

    now I understand the question.

    regards,
     
    wacamoi, Sep 23, 2008 IP