>> 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 _______________________________________________ Post Messages to: ProFox@leafe.com 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.