3 ms·
Does row count matter that much compared to data size? I.e. if I have a billion rows but they are 2 32-bit ints, that isn't a lot of data (2 GB + index). I gues
by brianwawok 10y ago
Does row count matter that much compared to data size? I.e. if I have a billion rows but they are 2 32-bit ints, that isn't a lot of data (2 GB + index). I guess the index starts to get pretty big.. but I always just think of raw data size vs # of rows.
- rantanplan 10y agoRemember, it's just a rule of thumb. Now... tables with 2 32-bit ints as columns are not exactly typical RDBMS data. Also, data in RDBMS are... well relational :) Meaning, the rows of just one table are not that important. The data are going to be queried and combined with data from other tables. And I know that typical relational data that consist of hundreds of millions of entries in each table is something that most DBs can handle. Again, rule of thumb :D
- brianwawok 10y agoFair enough!