>Have you looked at Task Manager and PerfMon on the server while your app is running? Is it CPU-bound, disk-bound, or ? What else runs on that box and what resources do those processes use?
>
>>I figured as much. I tried to set the limit higher but got a "Function argument value, type, or count is invalid." error.
>>
>>>>Currenty I'm setting both foreground and background memory limits to 2 gb. This server has 12 gb of memory. I've heard about problems on machines with more than 1 gb of memory. Everything appears to be working correctly but I want to be sure.
>>>
>>>VFP cannot handle more than 2GB of memory anyway.

Sorry, I'm late in responding to this issue. For some reason, your response wasn't sent to my email. This machine is a multi-processor, mult-core machine. Honestly, I'm not totaly familiar with this 2008 server monitor. The only surprise for me is the network activity during the process. Right now, nothing else is running on the machine. Eventually, we will have web connect com servers, serving up web pages.

I tested quite a few scenarios and the lenghty process is now taking 1 hour less on the new machine than it did on the old. I'm pretty happy with the results so far. Maybe, when I've got some more time, I'll re-visit this.