On Tue, March 25, 2008 4:26 pm, Mike yearwood wrote: > Hi Mike > > No. There is no such performance penalty. There may be a slight > benefit to using 1 line of code versus 4, but that's about it. If you tried > to use a Rushmore aware command like SET FILTER or LOCATE, they would run > slower if an order is set.
Very interesting. I had always heard that LOCATE was better to use than GO TOP, but applying what you've said, I guess that wouldn't be the case perhaps if there was a SET ORDER in place? > > The advice you got about SQL commands is incorrect. VFP SQL re-opens > the cursors in their own workareas so it can avoid any ORDER/SET FILTER > you've already put on the cursors. Thanks! --Michael _______________________________________________ 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.
