- Elias
Topic Author- Offline
- Administrator

Less More- Posts: 4306
- Thank you received: 0
5 months 2 weeks ago#3314by Elias How many rows can a database handle?
- Elias
Topic Author- Offline
- Administrator

Less More- Posts: 4306
- Thank you received: 0
5 months 2 weeks ago - 5 months 2 weeks ago#3315by Elias It depends on
- database limits
- hardware limits
see
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: 5 months 2 weeks ago by Elias.
- Forum
- Index
- Database
- How many rows can a database handle?
Time to create page: 0.082 seconds