Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locate in large table
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01394873
Message ID:
01394875
Vues:
97
This message has been marked as a message which has helped to the initial question of the thread.
>I have a very large table over 300,000 records
>
>I am using locate for command
>I can not use seek because I have conditions seek does not fulfill
>
>The first time a use the command locate,it is very slow
>
>The second time and then, locate is very fast
>
>The command is in a button of a form and table in date environment
>If I close the form, the first time I use locate it is slow again
>
>Is there any explanation for it ?

Are you by any chance starting out with a GO TOP command? That is not optimizable and will be very slow. Instead, issue LOCATE with no parameters. That will put the record pointer at the first record.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform