Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select SQL vs Copy to Array While... -- Which one wins?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00008720
Message ID:
00008952
Views:
33
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

Previous
Reply
Map
View

Click here to load this message in the networking platform