Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using SET EXACT and SUM
Message
De
01/02/2002 10:49:57
 
 
À
01/02/2002 10:44:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00612916
Message ID:
00614043
Vues:
23
Larry,

>Very interesting, however I question whther I would set EXACT always to OFF.
>Having EXACT on, works especially if you are doing an alltrim() ==
>

My point is that "==" causes the EXACT setting to be ignored...

>By placing the alltrim() in it slows down performance dramatically, what I have noticed using (3054,11) Rushmore in NONE .
>

A good reason to avoid alltrim() it if possible.

>We noticed tremendous performance degregation, with file sizes of 25K records plus
>
>We do a bunch of locate(), filtering, sum, seek() as well as SQL Select .
>
>Finally, we found out that one of our ex-programmers who left a year ago had not checked for Rushmore AT ALL, and our app. is a monster to say the least.
>

I hope you can kill the monster! *grin*

>
>Bye the way have you seen IncredeMail? If so how do you update their contact tables?
>

I've never heard of it...sorry.

>Thanks for the info. Have a great weekend.
>

You too!
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform