Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement