Information générale
Titre:
VFP8 OUTER JOIN evaluated before WHERE
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?
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