Really slow processing

[Kenneth Brody]

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