Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select SQL vs Copy to Array While... -- Which one wins?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00008720
Message ID:
00008952
Vues:
32
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

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform