Yeah, but those pesky users still want to be informed of what's happening. Trade offs, information vs speed. No mattter which you favor, in the user's point-of-view, you chose wrong. :(
Fred On Mon, Dec 5, 2011 at 3:59 PM, Michael Madigan <[email protected]>wrote: > I know just changing the odometer on giant databases when they are > reindexing is an enormous saving of time. Of course shutting off talk and > status would be even better. > > > ----- Original Message ----- > From: Charlie Coleman <[email protected]> > To: ProFox Email List <[email protected]> > Cc: > Sent: Monday, December 5, 2011 5:54 PM > Subject: Re: Vfp and counter > > At 04:49 PM 12/5/2011 -0500, MB Software Solutions, LLC wrote: > >On 12/5/2011 8:47 AM, Gérard Lochon wrote: > > >> That will show you a WAIT WINDOW every 100 rows processed. > ... > > m.todo = " of "+TRANSFORM(RECCOUNT())+" ..." > > > m.odom = 100 > > > GO TOP > > > > > > SCAN REST > > > SCAN NEXT m.odom > ... > > > WAIT WINDOW NOWAIT TRANSFORM(RECNO())+m.todo > > > ENDSCAN > ... > >Wonder how much more efficiency that really gets you? > > Obviously it is saving the MOD() function execution that would have > otherwise hit on every record. VFP is pretty darn fast for an interpreted > language, but dropping 1 line of code could be significant in tight loops. > We're probably talking maybe around .5 microseconds (based on machine speed > of course). So that'd be about .5 seconds every 1,000,000 records. > > But that's raw numbers. The thing is, if your code inside the loop takes > about 2 microseconds to process, the routine would appear to run 25% > faster. If the code took 5 microseconds to run, the routine would appear to > only get a 10% speed boost. > > I'm definitely tucking away this technique. I've got a couple cases where > I'm messing with multi-millions of rows. I'll try it both ways and see how > significant the difference is. > > -Charlie > > > [excessive quoting removed by server] _______________________________________________ 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/CAJCBksoeazSuaXyrv+n95DSx=wtdrgdrkdjkagfzkz+qjy2...@mail.gmail.com ** 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.
