Are you saying the version 9 software on your machine is also slow?
--- Dave Crozier <[EMAIL PROTECTED]> wrote: > 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.
