I have 3 VFP-9 applications installed at one client that have issues where they are slow to load, freeze up for all of the users using the app., and have problems saving where it "waits" until a record can be saved.
The apps. are on a Windows-2012 server with Win-7 and Win-XP workstations. There are 20+ users in an app sometimes. The EXEs are running from the server. The largest table has about 150,000 records. Separate views are used for each user.
Is there anything that I can tell their IT person to change on the server? They have (new) CAT-6 cabling with a Ghz switch. The workstations have 3/4 GB RAM and no internet access. I saw a previous post that said something about SMB2 but I don't know what to tell them.
Is there anything that I can change in my code to improve throughput?
Any thoughts would be appreciated - I feel like I may get fired....