When we got VFP, I made some benchmarks, for comparing SQL with standard xBase commands. A table with 200,000 records, 2 fields of 50 characters:
Action xBase SQL
-----------------------------------
Insertion 37:13 7:13
Delete 1:14 1:10
Indexed search 0:23 0:05
Non-Indexed search 0:47 0:37
Alex.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line