RDBMS for very large DB

Discussion in 'MySQL' started by rps111, Jul 2, 2007.

0
  1. #1
    I want to develop a web-based database with millions of enteries which will contain text and PDF files. I have initially started building the database in MySQL but read at many places that MySQL databases are very prone to corruption. So, in that case, which RDBMS should I try to get stability of database. My database will typically be around a few 100 GBs and will be periodically updated through web-forms built in PHP. Should I try making the 100GB+ DB in Oracle or some other DBMS? If then, which RDBMS should I try: MS SQL, Oracle, DB2 or some other?
     
    rps111, Jul 2, 2007 IP
  2. yugolancer

    yugolancer Well-Known Member

    Messages:
    320
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #2
    MySql is just fine DBMS but if you really want to try something that you must pay for then i recommend you MSSQL 2005 (if you have enough sources to buy that)

    Regards :)
     
    yugolancer, Jul 2, 2007 IP
  3. rps111

    rps111 Peon

    Messages:
    71
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks dude....but wat abt oracle...which shd b the best....money is no probs...
     
    rps111, Jul 2, 2007 IP
  4. turiel

    turiel Peon

    Messages:
    148
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If "money is no probs" then Oracle is the best you can buy. Its been the industry standard for many many years, its got the biggest feature set, performs well, and so on.

    Having said that, MySQL is just fine imho. If you want to pay for something, maybe consider one of their premium options where they come onsite (well, virtually speaking) and configure your database for optimal speed, performance, eliminate bottlenecks, etc.
     
    turiel, Jul 2, 2007 IP