Really slow processing

[Bob]

The upgrade included new hardware.  Not sure about the switch though.

FP runtime and data is on the server.  I map a directory on the server on 
each PC.......drive G..... and run everything across the network.

Question: Does this mean that fp is actually running the process locally and 
data is going back and forth across the network?

I've tried loading the runtime locally with data on the server but found no 
speed change.

----- Original Message ----- 
From: "Kenneth Brody" <kenbrody at spamcop.net>
To: "Bob" <roberth at sim-soft.com>
Cc: "fplist" <filepro-list at lists.celestial.com>
Sent: Friday, August 26, 2011 12:07 PM
Subject: Re: Really slow processing


> On 8/26/2011 12:57 PM, Bob wrote:
>> I've got a client that has recently upgraded from windows server 2003 to 
>> server 2008.  The workstations have been upgrade as well from xp to win7.
>>
>> What they have found is that when a selection routine is running (-v) 
>> it's taking substantially longer to select records.
>> ........there's over 1M records to select from.
> [...]
>> Notice the "close" statemnet in the lookup subroutine.  I commented this 
>> out to see the effect.  It made the process considerably faster but still 
>> much slower than the old system.  On the old system this would take maybe 
>> 3 or 4 minutes and now it's taking at least 10X that much.
>>
>> Any suggestion on speeding the process?
>>
>> Oh, they are running fp 5.0.9 I believe.
>
> By "upgraded from 2003 to 2008" and "upgraded from xp to win7", do you 
> mean "replaced with new systems that are meant to use these newer O/S 
> versions" or "kept the old hardware, and just replaced the O/S, even 
> though these old systems can't handle the new O/S"?
>
> If the former, then did they replace the network hardware as well? 
> Someone else on the list found that after such an upgrade, there was a 
> problem with one of the network switches that was bringing it to a crawl.
>
> If the latter, then it may simply be a case of the old hardware not being 
> able to run Win7 well.  (Win7 will run much slower than XP did on the same 
> box.)
>
> -- 
> Kenneth Brody