The best way to work with a billion rows is to architect your database (and your data) for a trillion rows.
3 weeks ago | 26
What can incase of a monitoring application where you have to store data from numerous sensors every minute/seconds? And you can rearchitect the table in a way that a billions rows are avoided
3 weeks ago (edited) | 0
How are you going to persist data about each human in the world without billions of rows?
3 weeks ago | 0
Hussein Nasser
The best way to work with billions of rows is to avoid working with billions of rows.
Everything from indexing, partitioning, sharding does exactly that.
And ever better if the billions of rows can be avoided all together during the application design.
3 weeks ago | [YT] | 407