>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only