KNOWLEDGE BASE
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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.