Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New machine choking on slow processes
Message
From
18/02/2011 12:42:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
New machine choking on slow processes
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01500754
Message ID:
01500754
Views:
130
I've got a method which process 14000 records in a scan loop. On the older machine, the process might take 10 minutes. The new machine takes hours. I've attempted to adjust the paging file memory size, but this hasn't helped.

In the scan loop, there is a replace which is not optimized which is taking about 3 secords per record on the new machine. I realize that the process needs to be optimized but I'm short of time and I don't have time to do it now.

Why would there be such a disparity in time?

The code is identical. The other major change is upgrading from VFP 8 to VFP 9.
Next
Reply
Map
View

Click here to load this message in the networking platform