Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What to use, SET EXACT ON or ==?
Message
 
À
16/02/2007 19:53:13
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01196479
Message ID:
01196846
Vues:
8
>Hi,
>I have recently done some performance testing on large datasets in VFP9, as result we are now using SET EXACT ON & SET ANSI ON and not using "==" as it does have a perceivable impact on performance when processing large amounts of data.

SET EXACT ON and == are NOT equivalent. == compares strings for exact equality while SET EXACT ON pads the shrter string with spaces and then comapres them. This means that if the difference vetween two strings is trailing spaces then SET EXACT ON will NOT notice the difference while == will.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform