Sytze, How are you updating the field "Replace..." or "update..."?
Certainly you shouldn't notice any speed degradation using either. If anything you should decrease speed of execution considerably. Things to look for are: Make sure you have "Set tablevalidate 0" To Emulate VFP7 have "Set enginebehavior 70" And "Set Optimize on" which it SHOULD be by default anyway. The enginebehavior shouldn't affect update performance though but is worth setting if you haven't crafted your SQL statements to ANSI standards (Group by and union). Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: 25 October 2006 05:11 To: [email protected] Subject: Slow VFP9 Hi foxers I have just come back from Papua New Guinea where I have several clients using some customised one-off packages. I needed to add some specific routines and took the opportunity to upgrade from VFP6 to 9. Oh horror of horrors. The following day, 2 of them called me and asked what on earth I had done !! Both programs (different programs altogether) have a specific routine of replacing a field with a computed field. The field is a simple numeric field and the number is updated according to the exchange rate of the day. The number of records is about 10,000. On my laptop it takes less than 2 secs. With VFP6, on the workstation, it takes less than 10 secs. With VFP9 it takes anywhere from 5 to 10 mins. Re-indexing all tables takes less than this !! I've turned AV off, no difference. I've run the application over T/Server and it takes less than 10 secs I've gone grey Sytze [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 ** 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.
