Most efficient database storage system/method?

Discussion in 'Databases' started by Helado, Sep 6, 2009.

0
  1. #1
    Hi, my site is going to have billions of entries rather soon, and I'm currently using MySQL for the database... it's good, but will it be able search through billions of rows quickly?

    Also, what is the most efficient database storage system/method? You've got flatfile, which is stressfull on the server in huge amount, and MySQL... what else (that's good)?

    Thanks.
     
    Helado, Sep 6, 2009 IP
  2. adithya

    adithya Well-Known Member

    Messages:
    568
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #2
    I think MYSQL is best.. take for example this forum itself.. i think its database itself occupied atleast 0.5-1 GB but still working fine :) but yes it will stress a server but compared to other DB storage system its less IMO
    Though some say oracle is best it requires oracle db software(which is paid one) in the server and also you should learn it from scratch
     
    adithya, Sep 6, 2009 IP
  3. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #3
    premiumscripts, Sep 7, 2009 IP
  4. Helado

    Helado Peon

    Messages:
    696
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Ah right. Thanks (to you both). So is there much difference with efficiency/speed on different engines?
     
    Helado, Sep 7, 2009 IP
  5. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yes, you should choose the engine that best fits for your project. There are more than those listed on that page, like for example https://launchpad.net/drizzle
     
    premiumscripts, Sep 7, 2009 IP