Thank you Tracy,I'll review that with my customer. Philip
---------- Original Message ---------- From: "Tracy Pearson" tracy@powerchurch.com To: profoxtech@leafe.com Subject: RE: DBFs Server 2012 R2 very slow with Certain Processors Date: Thu, 2 Jul 2020 11:47:42 -0400
What I have seen is a couple of network bottleneck issues.
1) The VFP exe should be on the local machine and accessing the data on the network. This removes a security layer and a network layer that happens when a section of the binary needs to be read. My VFP exe is over 20 MB.
2) The network card may have a burst setting that is set to high for the network to handle. My laptop is an i7-8550U and the onboard adapter needed to be adjusted. I had issues transferring files between a Linux system and the Windows 10 64-bit laptop over SFTP until I turned off the Burst. Mine is called "Throughput Booster"
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Philip Borkholder Sent: Thursday, July 02, 2020 11:11 AM To: profoxtech@leafe.com Subject: DBFs Server 2012 R2 very slow with Certain Processors
We a client using an ERP systems in VFP9 DBFs for their data. One of their users just got a new Dell XPS Notebook it has super slow results.It has an i7-9750H gen Intel processor with Win 10 64bit connecting to Windows Sever Essentials 2012 R2 server It is using a 1GB Card and shows it is connected at 1GB speed.I set the LanManWorkstation settings for to avoid CDX corruption:[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorks tation\Parameters] FileInfoCacheLifetime = 0FileNotFoundCacheLifetime=0DirectoryCacheLifetime=0 I have not made any changes with SMB1, 2 or 3 Their Hardware tech sent me this article form 2018 that states (Note: The author wrongfully mentions VFP 10, ignore that, it has nothing to do with this issue)https://community.spiceworks.com/topic/2161246-win-10-64bit-latest-int el-processor-slow-accessing-foxpro-over-network Has anyone else experienced super slowness using DBFs in the above situation related to 8th gen Intel processors or higher?NOTE: Other stations are not experiencing this on the same network.We've tried plugging into different ports on the switches and same results. We're kind of desperate to find a solution. (SQL DBs are in the long term plans, but looking for a solution for the DBFs ASAP) Thanks Philip B.Vicksburg, MI
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---