(CAS) filePro Speed on Windows 200x Server
Chris Sellitto
sellich at guaranteedreturns.com
Fri Feb 3 09:53:52 PST 2006
Hello All,
I have a question that has been nagging our company for years now, but we just put up with it. I will give you some background information to hopefully help you maybe diagnose the issue. For years we ran on a Novell 5.x NOS, using filePro 4.X. All workstations were a mix of Windows 98/98se/XP. All ran relatively quick. We then upgraded to filePro 5.X, and noticed a slight degrade in the speed, but nothing we could not deal with. When we moved locations, we decided to change over from Novell to Windows 200x servers. It was then we noticed a significant downgrade in the speed of filePro. A perfect example of this is when I created a process to read in a .CSV file and export it into a filePro 5.x file (without indexes). In approximately 3 hours time it had only created 30 some odd thousand records out of the 500,000 that needed to be exported. I stopped the process, and started it up on one of our test machines (also a Windows 2000 server) running a filePro 4.8 version. Not only did it run fast, it imported 9 files, of the same amount of records, in about an hours time.
My question is, is there anything that any of you could think of that we could do, or check that could possibly help make filePro 5.x run faster on a Windows 200x server? If you need more answers to any questions, please feel free to ask.
Any suggestions will be greatly appreciated.
Below is a copy of our config file
====================== START OF CONFIG ====================================
printer1=wareh,EPSONFX,
printer2=laser,HPLASER4,
printer3=office,IBMPRO,
pfprinter=newhp
prefix=gr
pfver=on
abe=ascii
pfedfailbox=on
printer4=shiplab,IBMPRO,lpt2
printer5=newhp,HPLASER4,lpt1
printer6=receive,IBMPRO,
printer7=fax,IBMPRO,g:\faxauth\fcover.txt,fileforfaxing
printer8=temp,HPLASER4,c:\temp.txt,generaltemp temp file
pftoksize=200000
printer9=indlbl,IBMPRO,com1:,rollerindates
pfbreak=old
pfcmark=50
pfclock=off
pfnet=on
pfhcff=on
pfign=acdefhjwz
pftmp=c:\fptemp
printer10=presrt,ibmpro,lpt1,presort process lpt1
printer11=prsrt3,ibmpro,lpt3,presortprocesslpt3
printer12=temp,nocodes,c:\nocode.txt,general temp file
printer13=form222,epsonfx,lpt1,Form222Controlslpt1
printer14=indlbl2,ibmpro,com2:,rollerindates
printer15=arslabel,okiml321,lpt3,ars label printer
pffiles=25
pfretry=50
pfsync=All
pfautoksize=125000
pfformtoksize=200000
pfdropshadow=on
pfnohelp=on
pfshowwinerror=on
PopupNormal=0x3f
PopupInverse=0x1f
MenuNormal=0x17
MenuInverse=0x4f
HelpNormal=0x5f
HelpInverse=0x74
ErrorNormal=0x4f
ErrorInverse=0x70
Colors:
TextNormal=0x17
TextInverse=0x4f
====================== END OF CONFIG ====================================
Our environment variables are as follows...
PFDATA=G:
PFDIRFILTER=OFF
PFDSK=g
PFNET=on
PFPROG=g:
G: being our mapped drive.
Thank You
Christopher Sellitto
VP Computer Operations
Guaranteed Returns
More information about the Filepro-list
mailing list