Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to improve the speed
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00185626
Message ID:
00185772
Views:
23
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform