- Posts: 3957
How many rows can a database handle?
- ekatsa
- Topic Author
- Offline
- Admin
Less
More
2 weeks 5 days ago #3314
by ekatsa
How many rows can a database handle? was created by ekatsa
How many rows can a database handle?
Please Log in to join the conversation.
- ekatsa
- Topic Author
- Offline
- Admin
Less
More
- Posts: 3957
2 weeks 5 days ago - 2 weeks 5 days ago #3315
by ekatsa
Replied by ekatsa on topic How many rows can a database handle?
It depends on
The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, even if the storage engine is capable of supporting larger rows. BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row.and Oracle allows two bytes for row numbers, so theoretically they could go as high as 65535 rows in a block.
However, given the minimum row length (11 bytes) and maximum database block size (32K), the pratical limit on the number of rows in a block is in fact only 2970.
- database limits
- hardware limits
The internal representation of a MySQL table has a maximum row size limit of 65,535 bytes, even if the storage engine is capable of supporting larger rows. BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row.and Oracle allows two bytes for row numbers, so theoretically they could go as high as 65535 rows in a block.
However, given the minimum row length (11 bytes) and maximum database block size (32K), the pratical limit on the number of rows in a block is in fact only 2970.
Last edit: 2 weeks 5 days ago by ekatsa.
Please Log in to join the conversation.
Time to create page: 0.222 seconds