Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query optimization
Message
De
23/08/2002 18:23:21
 
 
À
23/08/2002 17:22:17
Rodolfo Novoa
Consultor Independiente
Tegucigalpa, Honduras
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00692890
Message ID:
00693171
Vues:
17
Rodolfo,

After you closed/reloaded VFP each time, your SET ORDER TO... does NOTHING as regards the SELECT command. SELECT will re-open tables needed internally and use TAGs as it needs to, provided that they are there to be used AND provided that they comply to the rules for Rushmore.

So, to prove my point, you have to do a different sequence of test. Assuming that the current status is as you describe below, htne:
1) DELETE TAG i002
2) Close/restart VFP
3) USE the table (just so that it is found automatically by SELECT)
4) Execute the select, noting the time that it takes to complete.
5) Create TAG i002 as you did before
6) repeat steps 2-4 above.

You will see that the second run is much faster.

>Look, i test the two way:
>1. I create two tag
> a. index on codigo for !delete() tag i001
> b. index on codigo tag i002
>2. Close Visual foxpro
>3. Load Visual Foxpro , and i used de "DBFFile" with SET ORDER TO I001,
> Execute the Select Sentence, and it was faster
>4. Close Visual foxpro
>5. Load Visual Foxpro , and i use de "DBFFile" with SET ORDER TO I002,
> Execute the Select Sentence, and it was faster
>
>But, say you, that we can make , for change it. or Say me the number records of the table, and i will create it
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform