I wouldn't think so. From the command window I've seen a few cases where there might be a delay/pause. That's after a great deal of activity. Have you considered trying a sys(1104) to see what that does? Flushes are not required so I would definitely take them out to see what happens. What kind of improvement did you think would see, after optimizing the one view? Have a GREAT Thanksgiving... Regards, Desmond
> To: [EMAIL PROTECTED]> Subject: Flush command and system performance issues> > Date: Wed, 21 Nov 2007 12:43:11 -0500> From: [EMAIL PROTECTED]> > 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 or more> 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 of the flushes.> > I am > running out of ideas on how to speed up this form.> > Thanks in advance,> > Mike> > --------------------------------------------------------------------> > This mail sent through WebMail | Courtesy of Execulink> > > > > _______________________________________________> Post Messages to: > [email protected]> Subscription Maintenance: > http://leafe.com/mailman/listinfo/profox> OT-free version of this list: > http://leafe.com/mailman/listinfo/profoxtech> Searchable Archive: > http://leafe.com/archives/search/profox> This message: > http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]> ** All postings, > unless explicitly stated otherwise, are the opinions of the author, and do > not constitute legal or medical advice. This statement is added to the > messages for those lawyers who are too stupid to see the obvious.> > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
