General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Flush command and performance
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only