Still same slow problem even when SQL is run direct within VFP. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Allen > Sent: 06 September 2008 14:19 > To: [email protected] > Subject: RE: SQL > not optimised > > Why not make a VFP dll to run on ASP? > Allen > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On > Behalf Of NickC > Sent: 06 September 2008 15:05 > To: [EMAIL PROTECTED] > Subject: RE: SQL > not optimised > > One other thing worth a mention is that each record has 200 fields and is > almost 3k per record. > > Now if I > SELECT OrderNo from Orders INTO TABLE OrdPOOnly Then select from there all > is fine and works at a fast speed suggesting that the index is than being > used. Problem is that this OrderPOnumOnly is again taking around a minute > to extract. > > Nick > > > [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.
