View Poll Results: Which is the largest database you have worked with

Voters
9. You may not vote on this poll
  • <10 mb

    0 0%
  • 10mb - 100mb

    0 0%
  • 100mb - 1 gb

    0 0%
  • 1gb - 20gb

    4 44.44%
  • 20gb-200gb

    5 55.56%
  • >200gb

    0 0%
Results 1 to 9 of 9

Thread: Data Base Size

  1. #1
    Join Date
    May 2005
    Posts
    33

    Unanswered: Data Base Size

    So which is the biggest database you have worked with ?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sheer volume is meaningless, unless you're a hardware salesman

    what matters is complexity

    my biggest was 115 tables that i designed mineselbst

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    "In every large program there is a small program screaming to get out."
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    in every complex database there is a simple denormalized table screaming to get out
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by r937
    sheer volume is meaningless,

    So what you're saying is, size doesn't matter
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Sep 2005
    Posts
    161
    In a very large database, there is a full table scan waiting to ruin your day.

  7. #7
    Join Date
    May 2005
    Posts
    33
    By that count I have worked with about 310 tables at a time.... and there is a table i like to call MasterBuster .... tblCodes in which all simple master tables are combined.... about 35 odd

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ah yes, the One True Lookup Table (or OTLT as it is known)

    many otherwise intelligent modellers have fallen victim to the evil OTLT
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Sep 2005
    Posts
    161
    Quote Originally Posted by r937
    ah yes, the One True Lookup Table (or OTLT as it is known)

    many otherwise intelligent modellers have fallen victim to the evil OTLT
    I believe one reason the OTLT approach surfaced was because some early DBMS's had a small limit on the number of joins in one statement. I remember writing SQL statements with a limit of 8 joins... easy to exceed with lookup tables.

    I have quit OTLT's, cold turkey. It was almost as hard as giving up cigarrettes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •