>I converted a system running under FPW2.6 into VFP3.0 then to 5.0.
>Seems like many of the SQL statements that used to run like the wind
>now run like they are on crutches. What gives??? Any one else
>experience an extreme slowdown with VFP?
Let's see... there's a SYS() function that lets you know how much of the previous SELECT was optimizable. It's one of the highest numbers, but I don't have it memorized (yet :-) ). Also, with the new outer join syntax, there's a FORCE keyword that makes the tables join the way you think they should, rather than the way Fox wants them. This can improve speed a great deal, as I understand it....