Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the best index expression?
Message
 
 
À
19/04/2005 12:40:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01005870
Message ID:
01006259
Vues:
23
>Hi Nadya,
>
>>Also I was a little bit afraid to implement Fabio's idea of using IIF() for select correct alias, so I left more lines of code.
>if you are talking about
SELECT (IIF(cL_USE_AGAIN,m.lnSelRIDefi,"RIDefinitions"))
Here I'ld go a different way. Since the code opening/selecting RIDefinitions is only executed once per trigger, I'ld set m.lnSelRIDefi in this branch as well and during the rest of the code always select (m.lnSelRIDefi). Cleans the code up and is probably faster in most scenarios, especially if selection is needed often in the lower parts of the code.
>
>regards
>
>thomas

Thanks, I'm going to put it up.

It gave 2 sec. degradation, but I think, it's within the calculation error [how to say correctly - pogreshnost']
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform