>>I use to work with VFP 5.0 and its DBC, I'm sure it's a high capacity capacity database, but i just want to know: In practical terms, how many records has anyone of you handled using dbf files in production environment?

>There is no limit to the number of records in a table, only that the file size of the dbf cannot exceed 2 Gigabytes.
>
>I've worked with tables that contain over a million records with compound indexes consisting of up to 10 fields and have had them perform like a gem. Indexing, reindexing and packing, however, take longer with more records.

Hi Jeff. With VFP6SP3 indexing time has been drastically reduced. My 1 million record table (6 indexes) took 30 minutes to reindiex. That has dropped to about 11 minutes. Apparently Calvin Hsia is to thank for this.