Ok, I have a small internal application that I recompiled in VFP8. Mostly, no problems. BUT, I have a SELECT which is *really* slow in VFP8, and fast in VFP7.


*Simple example:

*(techs table: 25 records)
*(call table: 150,000 records)

SELECT ALL;
"" AS NAME;
FROM call LEFT OUTER JOIN techs ON init = UPPER(ALLTRIM(suppersn)); && this is slow.
WHERE .F.;
INTO CURSOR temp_stats

This should be really fast, as the WHERE should be evaluated before the JOIN. But it isn't (or doesn't seem to be).

Now, in VFP7, this takes at least 0.00 seconds. (The real query takes .27 seconds)

VFP8, at least .57 seconds. (the real query takes > 4 seconds)

Any thoughts?