KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Does using a subtable effect the maximum number or records in a table?
PRODUCT: 4D | VERSION: | PLATFORM: Mac & Win
Published On: May 2, 2002

Compatibility: 6.7.x and 6.8.x

An index table can contain up to 16,777,216 entries. This means that you may have up to 16,777,216 indexed keys for a table. If you are using a subtable record type in a table, you may not have up to 16,777,216 records for that table. Since a subrecord can be indexed, an average of 10 subrecords per record would mean that you can have index up to 1,677,721 records (ten times less). Of course, if you do not use subrecords, you may have up to 16,777,216 records in your table.

The error code -9997 is returned when you reach the limit of 16,777,216 records or the maximum number of indexed keys.