Hi Pierre,

Strictly a guess. . . were the indexes rebuilt after the collating sequence was changed? I've only ever worked with machine myself, so I have no idea what happens, but it seems like a possibility.

Good luck,

JimN

>I have an VFP5.0a application produced with Visual FoxExpress 5.0 in which I have a database containing some 20 tables & views.
>The application also has Stonefield Database Toolkit embedded for database maintenance & repair.
>Until last application's update, everything was fine & dandy. All original tables had compound indexes collated "machine". Then I decided to change them to "general" because I need to sort some accented characters (french).
>This is when that the performance dropped BIG TIME from what as instant to WELL over 10 seconds for a "one word" search in a table containing 32K records.
>I reversed all the chnages (i.e: indexes are now back to "machine") using the Stonefield Toolbox and I still have the same performance issue.
>Reversing the indexes back to machine hasn't improved anything. BTW this is the ONLY change that was done in the application before and after.
>Anyone has a suggestion as to what I need to do or look for to get back to my original performance ?
>TIA
>
>Pierre Richard