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\LanmanWorkstation\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-intel-pro... 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 ____________________________________________________________ Sponsored by https://www.newser.com/?utm_source=part&utm_medium=uol&utm_campaign=...
Congress Takes Stand Over Hong Kong Law http://thirdpartyoffers.netzero.net/TGL3241/5efdf96f762cc796f2039st04duc1 The World's Richest Person Is Now Richer Than Ever http://thirdpartyoffers.netzero.net/TGL3241/5efdf96f91796796f2039st04duc2 Jeffrey Epstein Confidant Ghislaine Maxwell Arrested http://thirdpartyoffers.netzero.net/TGL3241/5efdf96fac050796f2039st04duc3
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
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 ____________________________________________________________ Sponsored by https://www.newser.com/?utm_source=part&utm_medium=uol&utm_campaign=... ines_more
Congress Takes Stand Over Hong Kong Law http://thirdpartyoffers.netzero.net/TGL3241/5efdf96f762cc796f2039st04duc1 The World's Richest Person Is Now Richer Than Ever http://thirdpartyoffers.netzero.net/TGL3241/5efdf96f91796796f2039st04duc2 Jeffrey Epstein Confidant Ghislaine Maxwell Arrested http://thirdpartyoffers.netzero.net/TGL3241/5efdf96fac050796f2039st04duc3
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
On Thu, 2 Jul 2020, at 4:11 PM, Philip Borkholder wrote:
I set the LanManWorkstation settings for to avoid CDX corruption:[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters] FileInfoCacheLifetime = 0FileNotFoundCacheLifetime=0DirectoryCacheLifetime=0
Set them back to the defaults again (10 or 15 in each case IIRC), set to zero they can cause serious speed issues and aren't needed unless you are experiencing the particular corruption issues that zeroing them fixes. AFAIK recent Windows 10 versions have fixed whatever MS broke in SMB that caused these corruption issues in VFP (and MS Access).
-
Alan Bourke -
Philip Borkholder -
Tracy Pearson