Nope, no filters of any sort on the index. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Rick Schummer > Sent: 06 September 2008 14:35 > To: [email protected] > Subject: RE: SQL > not optimised > > >> I obviously didn't explain fully. This is an ASP webpage running on > IIS > which uses ADO to retrieve data from FoxPro tables. The Fox tables are > shared with thirty year old applications, so no chance of making any > substantial modifications to the table structures.<< > > By any chance, is the index tag on Order have a FOR filter? If so, this > tag is not optimized. You > need another tag on OrderNo without the FOR clause. You can use SYS(3054) > to determine the > optimization level in VFP (not via ADO). Once you have it fully optimized > I n VFP your query via ADO > and the OLE DB driver should work faster. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com > > > > > [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/!&[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.
