2.4k questions

2.4k answers

97.7k users

6 Online Users
0 Member 6 Guest
Today Visits : 935
Yesterday Visits : 1607
Total Visits : 2416787



Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc


Viktoria Katsanioti,




0 votes

How many rows can a database handle?
in General by (95.8k points)

1 Answer

0 votes

It depends on

  1. database limits
  2. 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.


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.

by (95.8k points)