>Hi,
>
>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?
>
>
>
>Thanks
>
>Juan Carlos

Juan,

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.

-JT