>> 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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement