>>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?
>
>Well I've had some tables which were about 1.7 GB, The number of records don't really matter, The limitation is 2 GB per table. Even with these large tables VFP performs pretty well as long as you define your indexes well.

Especially that deleted() tag. :-)

Thanks to your thread, I have removed this tag from tables that have few deletes. Things seem a little snappier.