Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SET EXACT and SUM
Message
From
01/02/2002 10:49:57
 
 
To
01/02/2002 10:44:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00612916
Message ID:
00614043
Views:
22
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform