Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEXSEEK is faster than SEEK
Message
 
À
03/01/2001 10:59:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00458942
Message ID:
00459291
Vues:
23
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
From what I have read I was under the impression that there wouldn't be any performance increase using INDEXSEEK() over SEEK(). I have a looping counting and totaling procedure where all I did was change a SEEK() to INDEXSEEK() with the move record pointer parameter set to .T., the time the procedure took with the SEEK() was 363 seconds, after changing to INDEXSEEK() the procedure takes 8 seconds. This occurs no matter if I reboot after each run or not, so caching isn't an issue.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

I've run into the same, Greg. It is quicker in nearly every case I have benchmarked. I can't say that I have ever seen differences as extreme as the ones you mention, though.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform