I doubt that any pre-VFP9 FLUSH command (i.e. without the added clauses) would have such an effect.

There is something about ensuring that the CODEPAGE of all tables be the same else slow queries happen.

Good luck.


>I have been moving an application written in VFP5 to VFP9. There was one view, that was not rushmore optimizable, and I have fixed that. Yet, there is no speed improvement. (I didn't write the original program, and have no contact with the original programmer.)
>
>I have noticed, that in the previous code, there are a number of flush statements. Especially after requery of view or update of the view.
>
>Would these flushes, cause a slowdown? even as much as upto 30 seconds in some cases?
>
>Do you think that they are necessary? i.e. Could I remove them from the code and it would still work? (Maybe do a final flush when form is closed instead of above?)
>
>Using the coverage profiler, the places highlighted as slow spots are the requeries, updates etc. But these lines happen before any flushes.
>
>I am running out of ideas on how to speed up this form.
>
>Thanks,
>Mike