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.

The biggest SQL database you own?

Discussion in 'MySQL' started by davidelvar, Jun 12, 2006.

0
Page 2 of 3
  1. honestman

    honestman Member

    Messages:
    80
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #21
    I want to know how you backup your database?
    It is hard to transfer a 1+ G file by Internet.
     
    honestman, Jul 1, 2006 IP
  2. scottj

    scottj Peon

    Messages:
    168
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #22
    Those are all weak. The largest DB that I manage is around 1.4TB! :D
     
    scottj, Jul 1, 2006 IP
  3. honestman

    honestman Member

    Messages:
    80
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #23

    Is this Data Warehouse in the legend?
     
    honestman, Jul 2, 2006 IP
  4. sandossu

    sandossu Guest

    Messages:
    2,274
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    0
    #24
    What website does have this DB? :confused:
     
    sandossu, Jul 2, 2006 IP
  5. scottj

    scottj Peon

    Messages:
    168
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #25
    Not sure what you mean.

    It's a collection of user tracking data gathered from hundreds of websites.
     
    scottj, Jul 2, 2006 IP
  6. anurag_online

    anurag_online Well-Known Member

    Messages:
    1,520
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    160
    #26
    Crap.. mine is roughly 30 MB included in 6 Different sites :p
     
    anurag_online, Jul 2, 2006 IP
  7. chandubhai

    chandubhai Banned

    Messages:
    556
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #27
    1.2 GB here!! wondering how do you manage quering 4.5 GB.
     
    chandubhai, Jul 2, 2006 IP
  8. scottj

    scottj Peon

    Messages:
    168
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #28
    It's all about indexes and query optimization.
     
    scottj, Jul 3, 2006 IP
  9. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #29
    Yes, that is why we burn them to DVD. About 120GB+ per month, we can fit about three months (one quarter) per DVD
     
    sadcox66, Jul 3, 2006 IP
  10. scottj

    scottj Peon

    Messages:
    168
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #30
    I want to know where you get DVDs that hold 360GB. ;)
     
    scottj, Jul 3, 2006 IP
  11. bobisawsome7

    bobisawsome7 Notable Member

    Messages:
    1,466
    Likes Received:
    104
    Best Answers:
    0
    Trophy Points:
    200
    #31
    I was wondering the same :D there's roughly an internal hard drive that holds that :p
     
    bobisawsome7, Jul 3, 2006 IP
  12. scottj

    scottj Peon

    Messages:
    168
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #32
    There are 750GB drives out now. That's no sweat for a hard drive. But there aren't even any DVDs planned that will hold 360GB.
     
    scottj, Jul 3, 2006 IP
  13. BIGC

    BIGC Peon

    Messages:
    612
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #33
    SQL in GBs is hard to maintain ..mine is 200MB
     
    BIGC, Jul 3, 2006 IP
  14. reddy123

    reddy123 Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #34


    I dunno how big is my database i'll check my site is www.jobs-bank.com
     
    reddy123, Jul 4, 2006 IP
  15. giraph

    giraph Guest

    Messages:
    484
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #35
    My biggest database is 1.2MB :).
     
    giraph, Jul 8, 2006 IP
  16. sllik

    sllik Active Member

    Messages:
    419
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #36
    Yeah, mine's around maybe 250MB, I don't see how someone can reach such a high size like 4.5GB...
     
    sllik, Jul 9, 2006 IP
  17. talkwebz

    talkwebz Banned

    Messages:
    1,117
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    0
    #37
    My dad is learning datawarehouse. It cost a lot to buy datawarehouse people and my dad is learning how to do it. Basically it takes all the sql(datbase)oracle, mysql any kind of database and then combines it so its easier to search and stuff. Well my dads good at computers. hes going to be phd soon. he he
     
    talkwebz, Jul 9, 2006 IP
  18. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #38
    How would you go about "downloading" the DMOZ database... just in case someone might wish to do the same? Scrape-n'-Store or is it available to download somewhere?
     
    ccoonen, Jul 11, 2006 IP
  19. bpearson

    bpearson Peon

    Messages:
    173
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #39
    bpearson, Jul 11, 2006 IP
  20. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #40
    Sweeeet! Now - if their was any way to Auto-Dump this RDF Category Structure into my PHPLinkDirectory 2.0 DB.
     
    ccoonen, Jul 11, 2006 IP
Page 2 of 3