<DIV id=RTEContent>Chris,</DIV> <DIV> </DIV> <DIV>I can't tell you what is wrong but as way of comparison.....</DIV> <DIV> </DIV> <DIV>We run filePro ODBC (16 user) on a 3 server win2000 network with approx 25 work stations. In addition to fp , our other main software runs in MS SQL Server. Most workstations would typically have both programs up and running along with Outlook, Word or Excel . Some woiuld also have Act 2005 or Surfcam running. All of these are heavy resource hogs. Bottom line we have very little degredation in speed from older versions of fp. (Note I go back to Profile II on an Radio Shack model 2).</DIV> <DIV> </DIV> <DIV>As for your CSV files, every night I update 12 Excel (dif) files to filepro. They range from 8,000 to 76,000 records each. The total process takes 45 minutes.</DIV> <DIV> </DIV> <DIV>I'd say you have a problem somewhere but I don't know where to tell you to start looking.</DIV>
<DIV> </DIV> <DIV>Sorry and good luck,</DIV> <DIV>Rick Hane, Controller</DIV> <DIV>DeLuxe Stitcher Company</DIV> <DIV><A href="http://www.deluxestitcher.com">www.deluxestitcher.com</A></DIV> <DIV> </DIV> <DIV><BR><BR><B><I>Chris Sellitto <sellich@guaranteedreturns.com></I></B> wrote: <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Hello All,<BR>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.<BR><BR>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.<BR>Any suggestions will be greatly appreciated.<BR><BR>Below is a copy of our config file<BR><BR>====================== START OF CONFIG
====================================<BR>printer1=wareh,EPSONFX,<BR>printer2=laser,HPLASER4,<BR>printer3=office,IBMPRO,<BR>pfprinter=newhp<BR>prefix=gr<BR>pfver=on<BR>abe=ascii<BR>pfedfailbox=on<BR>printer4=shiplab,IBMPRO,lpt2<BR>printer5=newhp,HPLASER4,lpt1<BR>printer6=receive,IBMPRO,<BR>printer7=fax,IBMPRO,g:\faxauth\fcover.txt,fileforfaxing<BR>printer8=temp,HPLASER4,c:\temp.txt,generaltemp temp file<BR>pftoksize=200000<BR>printer9=indlbl,IBMPRO,com1:,rollerindates<BR>pfbreak=old<BR>pfcmark=50<BR>pfclock=off<BR>pfnet=on<BR>pfhcff=on<BR>pfign=acdefhjwz<BR>pftmp=c:\fptemp<BR>printer10=presrt,ibmpro,lpt1,presort process lpt1<BR>printer11=prsrt3,ibmpro,lpt3,presortprocesslpt3<BR>printer12=temp,nocodes,c:\nocode.txt,general temp file<BR>printer13=form222,epsonfx,lpt1,Form222Controlslpt1<BR>printer14=indlbl2,ibmpro,com2:,rollerindates<BR>printer15=arslabel,okiml321,lpt3,ars label
printer<BR>pffiles=25<BR>pfretry=50<BR>pfsync=All<BR>pfautoksize=125000<BR>pfformtoksize=200000<BR>pfdropshadow=on<BR>pfnohelp=on<BR>pfshowwinerror=on<BR>PopupNormal=0x3f<BR>PopupInverse=0x1f<BR>MenuNormal=0x17<BR>MenuInverse=0x4f<BR>HelpNormal=0x5f<BR>HelpInverse=0x74<BR>ErrorNormal=0x4f<BR>ErrorInverse=0x70<BR>Colors:<BR>TextNormal=0x17<BR>TextInverse=0x4f<BR>====================== END OF CONFIG ====================================<BR><BR>Our environment variables are as follows...<BR>PFDATA=G:<BR>PFDIRFILTER=OFF<BR>PFDSK=g<BR>PFNET=on<BR>PFPROG=g:<BR><BR>G: being our mapped drive.<BR><BR>Thank You<BR>Christopher Sellitto<BR>VP Computer Operations<BR>Guaranteed Returns<BR>_______________________________________________<BR>Filepro-list mailing list<BR>Filepro-list@lists.celestial.com<BR>http://mailman.celestial.com/mailman/listinfo/filepro-list<BR></BLOCKQUOTE><BR></DIV>