>>>>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.
Précédent
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