2.4k questions

2.4k answers

97.6k users

4 Online Users
1 Member 3 Guest
Online Members
Today Visits : 1003
Yesterday Visits : 1185
Total Visits : 2413819

Categories

Notice

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

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
75 views

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

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.

by (95.8k points)
...