ProFox July 2020

profox@leafe.com

34 participants
34 discussions

RE: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 07 Jul '20

07 Jul '20

Thank you Dave, We did shut off all the power saving features of the NIOC. I'll try these other settings. Philip ---------- Original Message ---------- From: Dave Crozier <DCrozier(a)flexipol.co.uk> To: profoxtech(a)leafe.com Subject: RE: DBFs Server 2012 R2 very slow with Certain Processors Date: Tue, 7 Jul 2020 08:59:20 +0000 Philip, Check the NIOC and set it to default to 1Gb and not use the "Auto" feature to decide what speed it is running at i.e. in the Advanced Properties of the network card set Speed & Duplex to be 1.00Gb and set Auto Disable Gigabit to disabled (if this setting is present). Also, sometimes the "Green Ethernet" setting allows the NIC to go to sleep so try disabling this as well. Dave Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox <profox-bounces(a)leafe.com> On Behalf Of Philip Borkholder Sent: 06 July 2020 18:30 To: profox(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Thank you Ted, I'll have him test this out. When I looked at the properties of the NIC driver, it said it was connected at 1GB but that probably is what you were pointing out. Question to you though: won't the speedtest.net just test the Internet connection speed rather than the LAN speed? Thanks, Philip ---------- Original Message ---------- From: Ted Roche <tedroche(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Fri, 3 Jul 2020 15:07:17 -0400 Phil: 1. Can you confirm the local machine's network is actually running at full speed? Just because the driver thinks it's connected at 1Gbps doesn't mean it isn't rejecting 90% of packets. Try https://speedtest.net on this and another machine on the network to ensure there's not some blockage at the networking level. 2. Is it possible to (temporarily) move a set of DBFs locally to the machine, and see if the app runs okay with local data? This will determine if it is the local machine (bad CPU, bad RAM, something-something-local) or if the problem is the network or the server. In my experience, there's often a configuration problem on a new machine that needs adjustment. The machine's logs would show this. 3. Ensure the new machine is up to date in Windows updates and also drivers supplied by the vendor -- an amazing number of machines ship with software that doesn't work until it's updated. On Thu, Jul 2, 2020 at 2:08 PM Philip Borkholder <plborker(a)netzero.net> wrote: > I just set all three registry settings back to their > defaults:DirectoryCacheLifetime=10FileInfoCacheLifetime=10FileNotFound > CacheLifetime=5 There was no increase in speed. Anyone have any other > advice? > Thanks,Philip > ---------- Original Message ---------- > From: "Philip Borkholder" <plborker(a)netzero.net> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 2 Jul 2020 17:24:16 GMT > > Followup question Alan,When you stopped setting these to zero because > Win > 10 was "fixed" How did you leave the File Server LanManServer settings > for > :SMB1SMB2SMB3 Some recommendations out there state we need to shut off > SMB2 & 3 and turn on SMB1 on newer File Servers This File Server has > not shut off SMB2 or 3 My understanding was that the 3 Registry > settings I listed were set to zero then to compensate for not shutting > of SMB2 & 3 Thanks,Philip > > ---------- Original Message ---------- > From: "Alan Bourke" <alanpbourke(a)fastmail.fm> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 02 Jul 2020 17:44:36 +0100 > > 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\\\\Servi > ces\\\\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 > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]

1 0

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 07 Jul '20

07 Jul '20

Thank you Ted, I'll have him test this out. When I looked at the properties of the NIC driver, it said it was connected at 1GB but that probably is what you were pointing out. Question to you though: won't the speedtest.net just test the Internet connection speed rather than the LAN speed? Thanks, Philip ---------- Original Message ---------- From: Ted Roche <tedroche(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Fri, 3 Jul 2020 15:07:17 -0400 Phil: 1. Can you confirm the local machine's network is actually running at full speed? Just because the driver thinks it's connected at 1Gbps doesn't mean it isn't rejecting 90% of packets. Try https://speedtest.net on this and another machine on the network to ensure there's not some blockage at the networking level. 2. Is it possible to (temporarily) move a set of DBFs locally to the machine, and see if the app runs okay with local data? This will determine if it is the local machine (bad CPU, bad RAM, something-something-local) or if the problem is the network or the server. In my experience, there's often a configuration problem on a new machine that needs adjustment. The machine's logs would show this. 3. Ensure the new machine is up to date in Windows updates and also drivers supplied by the vendor -- an amazing number of machines ship with software that doesn't work until it's updated. On Thu, Jul 2, 2020 at 2:08 PM Philip Borkholder <plborker(a)netzero.net> wrote: > I just set all three registry settings back to their > defaults:DirectoryCacheLifetime=10FileInfoCacheLifetime=10FileNotFoundCacheLifetime=5 > There was no increase in speed. Anyone have any other advice? > Thanks,Philip > ---------- Original Message ---------- > From: "Philip Borkholder" <plborker(a)netzero.net> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 2 Jul 2020 17:24:16 GMT > > Followup question Alan,When you stopped setting these to zero because Win > 10 was "fixed" How did you leave the File Server LanManServer settings for > :SMB1SMB2SMB3 Some recommendations out there state we need to shut off SMB2 > & 3 and turn on SMB1 on newer File Servers This File Server has not shut > off SMB2 or 3 My understanding was that the 3 Registry settings I listed > were set to zero then to compensate for not shutting of SMB2 & 3 > Thanks,Philip > > ---------- Original Message ---------- > From: "Alan Bourke" <alanpbourke(a)fastmail.fm> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 02 Jul 2020 17:44:36 +0100 > > 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 > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]

2 1

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 06 Jul '20

06 Jul '20

Thanks Alan, I don't usually shut off SMB2 or 3 either, just others have suggested it on other forums. It always makes the speed worse. Philip ---------- Original Message ---------- From: "Alan Bourke" <alanpbourke(a)fastmail.fm> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Fri, 03 Jul 2020 12:00:09 +0100 I never touch any of that Philip. You want to be running on SMB2 or SMB3. They are orders of magnitude faster than SMB1 and much more secure. In fact on newer Windows servers SMB1 isn't even present any more. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Thu, 2 Jul 2020, at 6:24 PM, Philip Borkholder wrote: > Followup question Alan,When you stopped setting these to zero because > Win 10 was "fixed" How did you leave the File Server LanManServer > settings for :SMB1SMB2SMB3 Some recommendations out there state we need > to shut off SMB2 & 3 and turn on SMB1 on newer File Servers This File > Server has not shut off SMB2 or 3 My understanding was that the 3 > Registry settings I listed were set to zero then to compensate for not > shutting of SMB2 & 3 Thanks,Philip > > ---------- Original Message ---------- > From: "Alan Bourke" <alanpbourke(a)fastmail.fm> > To: profoxtech(a)leafe.com > Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors > Date: Thu, 02 Jul 2020 17:44:36 +0100 > > 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 > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server]

1 0

[NF] Hyper-V
by Charles Hart Enzer, M.D. 06 Jul '20

06 Jul '20

What problems might I have loading Hyper-V onto my PC WIN 10 Pro 64bit I want to run a WIN 3.1 and DOS programs I would install WIN 95 on Hyper-V -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

[NF] Workstation Installation Incompatible after WIN10 Upgrade
by Charles Hart Enzer, M.D. 06 Jul '20

06 Jul '20

For versions of VMWare Workstations 12 thru 15, *Troubleshooter* Program reports "Incompatible Program" Host is WIN 10 Pro 64 Bit Version 1909 C Drive is am SSD Installing to F Drive Error installing Workstation 15 *Setup cannot continue. The Microsoft Runtime DLL installer failed to complete installation* -- *Shai / שי **Charles Hart Enzer, MD(Retired, **Ohio**), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Retirement is **not What You are Retiring from* *Retirement is about What You are Retiring to* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 03 Jul '20

03 Jul '20

I just set all three registry settings back to their defaults:DirectoryCacheLifetime=10FileInfoCacheLifetime=10FileNotFoundCacheLifetime=5 There was no increase in speed. Anyone have any other advice? Thanks,Philip ---------- Original Message ---------- From: "Philip Borkholder" <plborker(a)netzero.net> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Thu, 2 Jul 2020 17:24:16 GMT Followup question Alan,When you stopped setting these to zero because Win 10 was "fixed" How did you leave the File Server LanManServer settings for :SMB1SMB2SMB3 Some recommendations out there state we need to shut off SMB2 & 3 and turn on SMB1 on newer File Servers This File Server has not shut off SMB2 or 3 My understanding was that the 3 Registry settings I listed were set to zero then to compensate for not shutting of SMB2 & 3 Thanks,Philip ---------- Original Message ---------- From: "Alan Bourke" <alanpbourke(a)fastmail.fm> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Thu, 02 Jul 2020 17:44:36 +0100 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 alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server]

2 1

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 03 Jul '20

03 Jul '20

Followup question Alan,When you stopped setting these to zero because Win 10 was "fixed" How did you leave the File Server LanManServer settings for :SMB1SMB2SMB3 Some recommendations out there state we need to shut off SMB2 & 3 and turn on SMB1 on newer File Servers This File Server has not shut off SMB2 or 3 My understanding was that the 3 Registry settings I listed were set to zero then to compensate for not shutting of SMB2 & 3 Thanks,Philip ---------- Original Message ---------- From: "Alan Bourke" <alanpbourke(a)fastmail.fm> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Thu, 02 Jul 2020 17:44:36 +0100 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 alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server]

2 1

Re: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 02 Jul '20

02 Jul '20

Thanks Alan,I thought we had to always have them set for Windows 10.I'll try that.-Philip ---------- Original Message ---------- From: "Alan Bourke" <alanpbourke(a)fastmail.fm> To: profoxtech(a)leafe.com Subject: Re: DBFs Server 2012 R2 very slow with Certain Processors Date: Thu, 02 Jul 2020 17:44:36 +0100 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 alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server]

1 0

DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 02 Jul '20

02 Jul '20

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-in… 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=rss_tag… 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 ---

3 2

RE: DBFs Server 2012 R2 very slow with Certain Processors
by Philip Borkholder 02 Jul '20

02 Jul '20

Thank you Tracy,I'll review that with my customer. Philip ---------- Original Message ---------- From: "Tracy Pearson" <tracy(a)powerchurch.com> To: profoxtech(a)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(a)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 ---

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2020