> 4. Re: Performance hits when using SET ORDER TO x on LAN tables? > (MB Software Solutions General Account) > Message: 4 > Date: Tue, 25 Mar 2008 16:51:47 -0400 (EDT) > From: "MB Software Solutions General Account" > <[EMAIL PROTECTED]> > Subject: Re: Performance hits when using SET ORDER TO x on LAN tables? > To: [EMAIL PROTECTED] > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > 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? >
LOCATE is faster than GO TOP - only if no order is set, SET DELETED is ON, and/or another FILTER is set. SET DELETED ON can be considered a filter. Mike Yearwood _______________________________________________ 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.
