FPW26 App runs slow on new XP Pro Machine. 1

[ricaruso]

My client has been running our app on a Win98 Peer-to-Peer network for years. When I installed a new Dell with XP Pro, which hosts the app., the SECOND workstation that runs the app takes approx. 35 seconds to open the database tables, which normally takes 2 seconds. The FIRST workstation that runs the app. over the network runs at the 2 second speed. However, if I host the application on the original Win98 machine, the speed returns to 2 seconds to open the database tables for all workstations.

They are running over the existing network and the XP box has 256MB RAM

Ric

 

[rgbean]

It's CRITICAL that if there is a Virus checker running on a workstation or server that it be configured to NOT actively check standard FoxPro files (.DBF, .FPT, .CDX) and on developer systems all the other file types. The basic information in the following article also applies to other AV apps depending on how they are implemented and how they can be configured.

http://support.microsoft.com/default.aspx?scid=kb;en-us;321550

- "HOWTO: Optimize Visual FoxPro Applications While Using Norton AntiVirus 2002"

Rick

 

[ricaruso]

Rick,

Thanks for pointing me in the right direction. Do you know what Antivirus works better with FoxPro in a mixed OS network (Win98/Win2K/XP)? Do you know if eTrust behaves the same or better than Norton or if one version of Norton works better than the other?

Thanks in advance,

Ric

 

[rgbean]

Actually, they all can (should?) be able to be configured NOT to check the standard table file types in thier real-time module. Obviously, if the system has to re-scan the entire .DBF (and .CDX) everytime some adds, deletes or a record, then this is going to really slow things down!

Rick

 

[romanslovak]

I have the same problem with my FOXPRO 2.5 application. If the server is W98based station, the start is very fast. If the server is a XP computer, the w98 workstations open the app very fast (2 s), but XP workstations about 1 min. There are no antivirus software on server. Did You find the solution?

 

[ricaruso]

RGBEAN replied to my post and it was very helpful. Below is the URL that was posted. I found that you also need to "Disable Auto-Protect" at each workstation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;321550

- "HOWTO: Optimize Visual FoxPro Applications While Using Norton AntiVirus 2002

 

[romanslovak]

There are no antivirus software on workstations. I can't use the Microsoft KB solution, because I don't use Norton AntiVirus. Have You any idea to help me with my problem? Is the only solution a downgrade to W98 on all workstations? When I run a foxpro application directly on XP server, the program starts very fast. Thank You for help in advance.

 

[rgbean]

XP really isn't a server - have you considered Win 2003? What protocol(s) are you running - is it an all and only IP network?

Rick

 

[ricaruso]

Your symptoms seemed like they stemmed from antivirus software. If you are not running any antivirus software on the entire network, then it could be a networking issue. You might want to try a host file on each workstation. Also, there is a book by Hentzenwerke Publishing “Painless Legacy FoxPro Applications on Modern Networks” that might be a resource worth investigating (

http://www.hentzenwerke.com).

Ric

 

[romanslovak]

Thank for Your answers. There are only TCP/IP protocol on the network. The "server" is Windows XP home edition. I know , this is not a true server like Windows 2003, but for file sharing it seems to be good. I tried to copy a big file over network. The time between XP and XP was much shorter than between XP and W98.
I have tried to share the files on the W98 machine. The new problem appeared. Sometimes if I want to run Foxpro app on XP clients , I get the error message "15 Not a database file". The W98 clients have the files opened. All databases (tables) are O.K.

 

[dbMark]

Have you read thread182-39481?

dbMark

 

[FoxEgg]

Download and use TameDos... It solves the file handling issues.

http://www.tamedos.com

FoxEgg

 

[jsams]

Hi Ric,

Sounds like the problem I was having. Check out Thread182-926135, "Error 1809 - FPW2.6 in XPRO".

John