Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Flush command and performance
Versions des environnements
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
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