Hi Rick, Fully Optimised. Only index is on OrderNo field all others deleted for testing.
Nick > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Rick Schummer > Sent: 06 September 2008 18:58 > To: [email protected] > Subject: RE: SQL > not optimised > > >> I like your theory but unfortunately still doesn't help speed this up. > According to SYS(3054) it is being optimised but even so still takes > almost > a minute to extract one record.<< > > Fully or partially. Big difference. > > In an earlier message you noted the table is wide, over 200 columns. What > about the number of tags > on the table, lots? I have witnessed VFP slowing down with wide tables > (lots of columns). One app I > reviewed took minutes to update a single record with a fully optimized > update statement. VFP also > slows down with lots of index tags. VFP caches the indexes on the > workstation where they are opened. > If VFP spends a lot of time moving indexes around, the network is flooded > and depending on the > design, overwhelmed. Could this be your problem? > > 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.
