RE: DBFs Server 2012 R2 very slow with Certain Processors
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
To: profoxt...@leafe.com
Subject: RE: DBFs Server 2012 R2 very slow with Certain Processors
Date: Tue, 7 Jul 2020 08:59:20 +
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 dcroz...@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 On Behalf Of Philip Borkholder
Sent: 06 July 2020 18:30
To: profox@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
To: profoxt...@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
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,P
RE: DBFs Server 2012 R2 very slow with Certain Processors
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 dcroz...@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 On Behalf Of Philip Borkholder
Sent: 06 July 2020 18:30
To: profox@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
To: profoxt...@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
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"
> To: profoxt...@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
Re: DBFs Server 2012 R2 very slow with Certain Processors
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" To: profoxt...@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" > To: profoxt...@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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20200706.133106.1208...@webmail11.dca.untd.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
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 To: profoxt...@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 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" > To: profoxt...@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" > To: profoxt...@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_MACHINESYSTEMCurrentControlSetServicesLanmanWorkstationParameters] > > 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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20200706.132959.1208...@webmail11.dca.untd.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: DBFs Server 2012 R2 very slow with Certain Processors
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 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" > To: profoxt...@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" > To: profoxt...@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_MACHINESYSTEMCurrentControlSetServicesLanmanWorkstationParameters] > > 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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CACW6n4s3JhKw+7DhCMpTNkU5uYek+TEK=4gzmxui-mhfgpm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: DBFs Server 2012 R2 very slow with Certain Processors
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" > To: profoxt...@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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f5965d0f-2d1d-47f5-afbc-d3d6a8c89...@www.fastmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: DBFs Server 2012 R2 very slow with Certain Processors
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" To: profoxt...@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" To: profoxt...@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_MACHINESYSTEMCurrentControlSetServicesLanmanWorkstationParameters] > 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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20200702.140625.2727...@webmail04.dca.untd.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: DBFs Server 2012 R2 very slow with Certain Processors
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" To: profoxt...@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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20200702.132416.2727...@webmail04.dca.untd.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: DBFs Server 2012 R2 very slow with Certain Processors
Thanks Alan,I thought we had to always have them set for Windows 10.I'll try that.-Philip -- Original Message -- From: "Alan Bourke" To: profoxt...@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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20200702.131325.2727...@webmail04.dca.untd.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: DBFs Server 2012 R2 very slow with Certain Processors
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 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/4a6185e4-48af-41b8-a5d7-8030e92ef...@www.fastmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: DBFs Server 2012 R2 very slow with Certain Processors
Thank you Tracy,I'll review that with my customer. Philip -- Original Message -- From: "Tracy Pearson" To: profoxt...@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-boun...@leafe.com] On Behalf Of Philip Borkholder Sent: Thursday, July 02, 2020 11:11 AM To: profoxt...@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 --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/20200702.121442.2280...@webmail05.dca.untd.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: DBFs Server 2012 R2 very slow with Certain Processors
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-boun...@leafe.com] On Behalf Of Philip Borkholder Sent: Thursday, July 02, 2020 11:11 AM To: profoxt...@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_medium=uol_campaign=rss_tagl 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] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000c01d65088$200d3880$6027a980$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
