Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert entries in messagebox to a comma-delimited list
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Divers
Thread ID:
00298547
Message ID:
00301390
Vues:
41
>I made tests today, I selected from lots of joined tables, which are very huge, and issue expression in where clause like:
>('A' $ Amenities or 'B'$ Amenities etc.) - it took 164 sec.
>(at('A',Amenities)>0 or at('B',Amenities)>0 etc.) - it took 202 sec. I haven't index on Amenities.
>So, my conclusion is that $ works faster than at() (at least, if I haven't index). I'm going to change my code appropriately.

Sounds good. I'm not surprised, I think AT() is slightly more complex than $.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform