Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed Difference
Message
 
À
08/01/2002 12:17:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00601821
Message ID:
00602085
Vues:
31
>Again, going back to the original question, he asked if a view would be faster. I threw in parameterized for free, but also mentioned query (referring to a SELECT) statement.

Yep, but the solution is quite different : have an index;

Now is it really so that for future we all should have views in order to make things faster ? Oh, for not too large files maybe ?

He was having a response of 1-2 seconds on a "skip" with his filter. Have an index and the response will be 0,01 (when other environmental things are right); Maybe the view could make it faster, but I won't do the effort.

No offence ment and no offence taken.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform