<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19120">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>What they have found is that when a selection
routine is running (-v) it's taking substantially longer to select
records.</FONT></DIV>
<DIV><FONT size=2 face=Arial>........there's over 1M records to select
from.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Here's the code:</FONT></DIV>
<DIV><SPAN lang=EN>
<P>::gosub setvar:<BR>::logtext "fl="{fl:<BR>:fl eq "":gosub enter:<BR>::gosub
getmst; gosub sel:<BR>::a=inkey:<BR>:a ne
"":exit:<BR>::end:<BR>setvar:::<BR>::xa(4,*,g); fl(1,*,g);
rn(1,.0)="1":<BR>::return:<BR>enter:::<BR>::input ("5","10") yn(1,yesno) "Post
Agent Balances(Y/N)":<BR>:yn eq "":goto enter:<BR>:yn eq
"N":exit:<BR>::fl="x":<BR>::return:<BR>getmst:::<BR>::lookup master r=rn
-n:<BR>::xd=master(14);xe=master(15):<BR>::master(14)="";master(15)="":<BR>::'close
master:<BR>::return:<BR>sel:::<BR>: 3 lt xd or 3 gt xe:return:<BR>:5 eq "C" or 5
eq "O":select:<BR>::return:</P></SPAN></DIV>
<DIV><FONT size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Any suggestion on speeding the
process?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Oh, they are running fp 5.0.9 I
believe.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial>Bob<BR>"The nonGeek
Geek"</FONT></DIV></BODY></HTML>