Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed Difference
Message
De
08/01/2002 15:12:40
 
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:
00602172
Vues:
31
Okay, I see your point. But I'm still biased in favor of using a view *grin*

>>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.
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform