Hi!
Look into your project files. Some files in the project might get new codepage.
In addition, do you have a backup copy? Even try for very old backup copy might put a light on the problem - just compare the speed in old and new on the same machine. Maybe problem is not in what you think.
>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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.