Log In    |    Knowledge Base    |    4D Home
Tech Tip: Database limits in 4D v11 SQL
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: November 19, 2007

With 4D v11 SQL the limits of 4D have been increased. You can now have up to:

-1 billion records per table (formerly 16 million)
-32,767 tables per database (formerly 255)
-32767 fields per table (formerly 511)
-a data file of size only limited by your OS, there are no more segments (formerly 127 segments of 2 GB each)
-128 billion index keys per table (formerly 16 million)
-255 characters in an Alpha field (formerly 80)
-2000 MB text fields (formerly 32 KB)

Please note that the database must be running in Unicode mode in order for the new character limits to be used.