>>>>>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?
>>>>
>>>>no -- make sure that the statements are rushmore optimized...
>>>
>>>They were optimized in 2.6...is there a reason why they woun't be in 5.0?
>>
>>check some older threads on this subject. i haven't had any problems like this, but some things did seem to change...
>
>I've found that by saving views and sqls in a database container they are much faster than a sql statement. I've timed sql statements on a half million record table that took up to 8 seconds on a optimized sql statement may be as fast as 2.5 seconds using a saved sql.

How did you do the timing??? Was the SQL SELECT statement pre-compiled? It is in the DBC.

Craig