3 ms·
Hardware has limits as well as software. You would need a completely different architecture to accomodate a 20M+ database. Usually schemeless the database overh
by Sparkyte 3y ago
Hardware has limits as well as software. You would need a completely different architecture to accomodate a 20M+ database. Usually schemeless the database overhead is typically what is responsible how many rows it handle and because your client interacts with the MySQL engine it is at limit and performance of that engine. So yeeeee-no. Time to use a different database.
- fastball 3y agoPostgres is also a relational DB and rows per table are "limited by the number of tuples that can fit onto 4,294,967,295 pages"
- Sparkyte 3y agoYep, it is all different. Software and hardware. But what it comes down to isn't the number but the performance and we often have to watch these metrics closely.
- Dylan16807 3y ago> You would need a completely different architecture to accomodate a 20M+ database. The article shows that nothing notable happens at 20M, so what limits are you talking about? One more level of depth on the B+ tree is very easy to deal with.