Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Vfp50 - VIEW or SET FILTER - which is best?
Message
De
26/03/1997 20:10:26
 
 
À
26/03/1997 16:54:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00025400
Message ID:
00025746
Vues:
34
>> I agree use a view, but I have a comment reguarding one person who said
>> views are faster. I am not sure. Efficient use of views requires the
>> correct indexes. I understand that set filter is Rushmore optomizable, so
>> with the proper indexes it could be just as fast
>
>to initialize a view is slower that to SET FILTER - as a view has to create a temporary
>file with the data subset and SET FILTER doesn't do that
>but when working with the subset views are faster as you already have the records a a
>small table and you don't have to search the fields matching the critiria
>
>also views scale better to C/S use
>
>Arnon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform