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.

Working with millions or billions of records

Discussion in 'MySQL' started by xhanch, Oct 17, 2009.

0
Page 2 of 2
  1. wildogre

    wildogre Well-Known Member

    Messages:
    1,018
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    128
    #21
    I'll also suggest oracle or MSSQL. Because it can handle larger amount of data.
     
    wildogre, Oct 31, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #22
    That's so good to hear. It gets a little interesting trying to cluster when you have a 100Gb database. Is that > 5.1 or >6.0? Have you switched DP over to 5.1 yet, or are you still on 5.0?
     
    jestep, Nov 2, 2009 IP
  3. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #23
    MySQL 5.1.6 was the version they introduced disk-based NDB tables for MySQL Cluster.

    Still running 5.0.xx here, for what I need, I haven't seen anything in 5.1.xx that warrants an upgrade.
     
    digitalpoint, Nov 2, 2009 IP
  4. xhanch

    xhanch Member

    Messages:
    683
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    35
    #24
    I have a full confidence using MySQL. They provide free stuff that can compete with Oracle and MSSQL.
    Now, I am looking forward to Full Text Indexing feature for InnoDB. I hope I can be relieved to use InnoDB for all of my tables. :)
     
    xhanch, Nov 3, 2009 IP
Page 2 of 2