4
devphobe
256d

How many total rows of data does your production database have?

Comments
  • 3
    What kind of survey is this?
  • 3
    A database penis contest?

    Finally an attractive, long number....
  • 1
    I don't even know how I would calculate that.....it's a lot...
  • 1
    Since 1 db contains a few million records alone.... I'm going to say millions.
  • 3
    0.
    Did I win? πŸ˜ƒ
  • 2
    @cafecortado yes! Best number I heard all day.
  • 2
    About 15 trillions
  • 2
    @Lyniven , my measly billion suddenly feels more manageable.
  • 1
    On my former job it was somewhere on the range of 5-6 billion rows, out of which 3.6 was in two tables of about 1.8 billion each.

    Current job not nearly as much in the dbs I work with but probably quite a lot in some of the other ones.
  • 1
    It’s over 9000!!
  • 0
    I think my/our db penis is bigger than yours..
  • 0
    To be honest, I couldn't tell.

    Largest I can easily remember was ~ 560 GB, in my first job. Since the database contained the order information, a large chunk of it was in a single table (order items followed by the order information).

    We switched at some point to UUIDs, which I remember because it was extremely painful, due to being close hitting the INT (Int 32) unsigned limit and BIGINT (Int 64) unsigned was for many reasons a very very bad idea.

    The rest... From small to big and everything in between.
  • 1
    I dont have a database..😁🀩
  • 1
    @cafecortado -1, I win😏
  • 1
    The number can change quite drastically if you normalize it or not.
  • 1
    1T, don't ask.... :(
Add Comment