×

Notice

The forum is in read only mode.

How many rows can a database handle?

More
3 months 2 days ago #3314 by Elias Katsaniotis,MSc
How many rows can a database handle?
More
3 months 2 days ago - 3 months 2 days ago #3315 by Elias Katsaniotis,MSc
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.
Last edit: 3 months 2 days ago by Elias Katsaniotis,MSc.
Time to create page: 0.103 seconds

Site Info

V. Katsanioti,

Russia,

Kaliningrad Oblast.

matizegr@yahoo.com

Visit counter

United States of America (the) 80.6% United States of America (the)
Russian Federation (the) 11.1% Russian Federation (the)
China 4.9% China

Total:

33

Countries
00001846
Today: 16
Yesterday: 55
This Week: 71
Last Week: 565
This Month: 1,766
Last Month: 81

Who's Online

We have 1424 guests and no members online