One of my tables is over 1 million records which is still small potatoes for VFP.

The eurotunnel project used 128 GB data, 24 hours/day (from Barbara's site).
The Universal Thread has over 400,000 transactions per day. Since this place runs on foxpro I would imagine a large majority of those are VFP database transactions.
Rick Strahl built the Surplus Direct site it had peaks "500,000+ VFP server hits a day and 28,000 VFP server hits per hour" (http://www.west-wind.com/presentations/largeweb/)


Here is system capacity from VFP6 help:
++++++++++++++++++++++
Table and Index Files
Maximum # of records per table file 1 billion
Maximum size of a table file 2 gigabytes
Maximum # of characters per record 65,500
Maximum # of fields per record(1) 255
Maximum # of tables open at one time(2) 255
Maximum # of characters per table field 254
Maximum # of bytes per index key in a non-compact index(3) 100
Maximum # of bytes per index key in a compact index(3) 240
Maximum # of open index files per table(2) unlimited
Maximum # of open indexes in all work areas(2) unlimited
Maximum # of relations unlimited
+++++++++++++++++++++++

The typical app won't even approach these numbers in actual usage.

>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?