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