2.4k questions

2.4k answers

96.3k users

8 Online Users
1 Member 7 Guest
Online Members
Today Visits : 1529
Yesterday Visits : 2514
Total Visits : 2369972

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
74 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)
...