Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to improve the speed
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00185626
Message ID:
00185772
Vues:
24
And the winner is (roll the drums): David Frankenbach!

Here are the result on a smaller record set (500 records):
- David Frankenbach: 20.750 seconds
- Mark Mccasland: 21.611 seconds
- Josh Weiss: 26.779 seconds
- My original program: 130.317 seconds

Rich Addison and Brad St. Germaine idea don't apply to my problem at hand because I need to check for duplicate in the SDF file itself, not with the master table.

With David solution, I estimate that the total time needed to import 42 485 records will be around 30 minutes instead of the 3 hours with my original idea!

I was surprised by Josh result: I didn't think that it would make that difference between a Rushmorized (!!!) LOCATE and a IndexSeek(). Even the Seek() was faster than the LOCATE.

Anyway, thanks to everyone for their much appreciated ideas.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform