DelphiFAQ Home Search:

FoxPro limits

 

comments2 comments. Current rating: 5 stars (2 votes). Leave comments and/ or rate it. Table and Index Files

Max. # of records per table1 billion*
Max. # of chars per record65,000
Max. # of fields per record255
Max. # of open DBFs225
Max. # of chars per field254
Max. # of chars per index key (IDX)100
Max. # of chars per index key (CDX)240
Max. # of open index files per tableunlimited**
Max. # of open index files in all work areasunlimited**

* The actual file size (in bytes) cannot exceed 2 gigabytes for single-user or exclusively opened multi-user tables. Shared tables with no indexes or .IDX indexes cannot exceed 1 gigabyte. Shared tables with structural .CDX indexes cannot exceed 2 gigabytes.

** Limited by memory. In FoxPro for MS-DOS and FoxPro for Windows, also limited by available MS-DOS file handles. Each .CDX file uses only 1 file handle. The number of MS-DOS file handles is determined by the CONFIG.SYS FILES parameter.

Field Characteristics

Max. size of character fields254
Max. size of numeric fields20
Max. # of chars in field names10
Digits of precision in numeric computations16

Comments:

2006-10-24, 23:06:32
anonymous from India  
rating
Good One.
2007-06-06, 09:13:17
anonymous from United States  
rating
Very nice layout of info here. I would like to comment that if one or more of your fields is created to allow null values then the maximum number of allowable fields per record is reduced to 254.

As tables approach the size limit having millions of records and size over a gigabyte re-indexing becomes time consuming. Keep your tables cleaned up if you can!

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: