VFP 9 Server Windows 7 Pro with XP as a client speed issue

I have an issue with our VFP 9 application, It was running on the network with both machines the server and client running XP pro. Well the old server machine died so he decided to buy a windows 7 machine (2.4 quad core, 12gb DDR3 ram, 64-bit OS). The application runs great when he is the only user logged in, but as soon as the XP computer opens the program it slows to a crawl. We have tried turning off SMB2, checking all permissions, running in compatibility mode. Before he goes out and buys a new Windows 7 pro machine, does anyone have any other suggestions i can try to make this application run as fast as it did when both machines were xp pro.

Tristan
TristanHowlandAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

WyoComputersCommented:
I would upgrade the XP machine to use CredSSP, there maybe some switching occurring that is causing issues with this.  There are 2 parts to the install, one updates RDP and the other is CredSSP.  Make sure you install both.  Also, make sure all machines are only using IPv4 NOT IPv6.

You must have CredSSP to allow windows XP to connect to windows 7 or XP secuely:

RUN THIS TO INSTALL IT:

http://support.microsoft.com/kb/951608

More info:

http://support.microsoft.com/kb/951616

http://systembash.com/content/remote-desktop-from-windows-xp-to-windows-server-2008-or-windows-vista/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pcelbaCommented:
This is obvious Windows 7 behavior. I cannot say why it is slower than XP but that's the fact...

Windows 7 license prohibits server usage of this OS so maybe Microsoft is slowing the access down intentionally...  You should rather go W2008 or W2012 way with appropriate number of client licenses.

What else could you check if you are sure SMB2 isn't the issue:
- Anti virus settings (remove data folders from virus checks)
- Make sure VFP temp files are going to the local drive
- Make sure the code page for the DBF and CDX match
- Execute the application from local drive not from the server folder
- All VFP run-time libraries (the latest version) must be on the local PC

Does your app work slowly when you execute it from VFP IDE ?

Update: You should also turn oplocks off on the server. More info: http://fox.wikis.com/wc.dll?Wiki~OpportunisticLocking
0
jrbbldrCommented:
A Windows 7 box is Not a SERVER.  
As Pavel has said above:   Windows 7 license prohibits server usage of this OS
It is a workstation-level machine being used as a 'server' and subject to all of its workstation OS limitations.

Before considering the purchase of another Windows 7 machine, think about buying a 'real' Server with Win 2008 or better.  

Keep in mind that if this application is BUSINESS CRITICAL, not prioritizing the budget accordingly will result in reduced operational effectiveness.

Good Luck
0
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

pcelbaCommented:
Of course, we(?) should clarify what is the "server usage". OK, Microsoft should clarify. How many users can access shared folder on W7 PC ? How many users can access the SQL Server Express installed on the W7 OS? May we use SQL Server Standard?  Is this SQL Server usage under W7 legal? Etc. etc.

Regarding W2008... I would test it first.  I've seen questions asking "Why is my VFP 9 app so slow on W 2008?" ...

Configuration and tuning is very important today.
0
TristanHowlandAuthor Commented:
Thanks everyone for their help with this issue. The trick was having ipv6 turned off, as soon as i disabled that it worked as usual without speed being impaired.

This was is just a temporary fix for them until they could get a server OS installed and configured.
0
TristanHowlandAuthor Commented:
ipv6 was the issue! Thanks!
0
pcelbaCommented:
Good to know. Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FoxPro

From novice to tech pro — start learning today.