Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Machine vs General collating & lost of performance
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
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