>> 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 _______________________________________________ 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.
