Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
Voxera113884yOn 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. -
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.
How many total rows of data does your production database have?
rant