ProFox

profox@leafe.com

2704 discussions

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

Re: ProFox archives error
by Philip Borkholder 02 Jul '20

02 Jul '20

Thanks Ed! Philip B ____________________________________________________________ Sponsored by https://www.newser.com/?utm_source=part&utm_medium=uol&utm_campaign=rss_tag… The World's Richest Person Is Now Richer Than Ever http://thirdpartyoffers.netzero.net/TGL3241/5efdf59d71997759d442bst02duc1 Jeffrey Epstein Confidant Ghislaine Maxwell Arrested http://thirdpartyoffers.netzero.net/TGL3241/5efdf59d8c93b759d442bst02duc2 Hiring Is Stronger Than Expected in June http://thirdpartyoffers.netzero.net/TGL3241/5efdf59da75f7759d442bst02duc3 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

ProFox archives error
by Philip Borkholder 02 Jul '20

02 Jul '20

Internal Server ErrorThe server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. Is there a different site to search ProFox archives?I keep getting this error. Philip B.Vicksburg, MI ____________________________________________________________ Sponsored by https://www.newser.com/?utm_source=part&utm_medium=uol&utm_campaign=rss_tag… In This State, the Party's Over http://thirdpartyoffers.netzero.net/TGL3241/5efd0fab5712ffab2dbcst02duc1 Fox Anchor Out Amid Sexual Misconduct Accusations http://thirdpartyoffers.netzero.net/TGL3241/5efd0fab73108fab2dbcst02duc2 Doomed Groom May Have Infected 100 at His Wedding http://thirdpartyoffers.netzero.net/TGL3241/5efd0fab8e3c9fab2dbcst02duc3 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

FoxPro Migration Job
by Ed Leafe 01 Jul '20

01 Jul '20

I just got this from a recruiter on LinkedIn. It’s not for me, but I thought I’d pass it along. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I am currently working on a position with a client of mine and feel you might be a qualified candidate for it. My client is looking for a Senior System Analyst. This candidate will help spearhead an ERP migration to newer technologies. Currently using FoxPro and will need knowledge in FoxPro. Other technologies needed: .NET/C#, SQL, etc. Progress 4GL and ERP experience will be a plus but not a requirement. This position is a full-time opportunity located in the Austin, TX area. I have a great relationship with their HR, so please get back to me ASAP. To speed the process, please let me know when you are available by phone and if you could, attach a final draft of your resume. Also, if you’re not interested, but you know other people who would be interested, let me know! I look forward to speaking with you soon! Henry Eaddy Executive Recruiter at Crawford Thomas Recruiting 407-960-5835 Henry.e(a)crawfordthomas.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Ed Leafe

1 0

ProFox List Statistics for June 2020
by List Administrator Account 01 Jul '20

01 Jul '20

================================================== ProFox List Statistics June 2020 ================================================== Subscriber Count at End of Month: ProFox: 295 ProFoxTech: 181 ================================================== Total Posts: 107 (Up 114.0% from May 2020) Total [OT] Posts: 0 (Unchanged from May 2020) Total [NF] Posts: 8 (Down 11.11% from May 2020) Daily Message Counts for June 2020 ------------------------------------------------ DOW Date Count --- ---- ----- M 1 - 1 W 3 - 4 T 4 - 1 F 5 - 6 M 8 - 3 T 9 - 1 W 10 - 9 T 11 - 4 T 16 - 2 W 17 - 10 T 18 - 5 S 21 - 1 M 22 - 1 T 23 - 20 W 24 - 19 T 25 - 6 F 26 - 5 S 27 - 2 S 28 - 1 T 30 - 6 Message Counts By Day of Week for June 2020 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 5 Tue - 29 Wed - 42 Thu - 16 Fri - 11 Sat - 2 Distinct Posters to the List (changes relative to May 2020) ------------------------------------------------ Non-OT messages: 24 (Up 14.29%) OT messages: 0 (Unchanged) NF messages: 4 (Unchanged) Total number: 24 (Up 14.29%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 26 MB Software Solutions, LLC 2. 11 Alan Bourke 3. 10 John Weller 4. 9 Ed Leafe 5. 7 Richard Kaye 6. 5 Jürgen Wondzinski 7. 5 Ted Roche 8. 4 Paul Newton 9. 3 Michael Savage 10. 3 Tracy Pearson 11. 3 Stephen Russell 12. 3 Eric Selje 13. 2 Malcolm Greene 14. 2 Man-wai Chang 15. 2 AndyHC 16. 2 Paul H. Tarver 17. 2 Vince Teachout 18. 2 Gianni Turri 19. 1 Jean Laeremans 20. 1 List Administrator Account Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 4 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Paul Newton 2. 2 Alan Bourke 3. 2 MB Software Solutions, LLC 4. 1 Richard Kaye Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 26 MB Software Solutions, LLC 2. 11 Alan Bourke 3. 10 John Weller 4. 9 Ed Leafe 5. 7 Richard Kaye 6. 5 Jürgen Wondzinski 7. 5 Ted Roche 8. 4 Paul Newton 9. 3 Michael Savage 10. 3 Tracy Pearson 11. 3 Stephen Russell 12. 3 Eric Selje 13. 2 Malcolm Greene 14. 2 Man-wai Chang 15. 2 AndyHC 16. 2 Paul H. Tarver 17. 2 Vince Teachout 18. 2 Gianni Turri 19. 1 Jean Laeremans 20. 1 List Administrator Account Top 10 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 John Weller 2. 3 MB Software Solutions, LLC 3. 3 Jürgen Wondzinski 4. 2 Michael Savage 5. 1 List Administrator Account 6. 1 Kurt Wendt 7. 1 Paul Newton 8. 1 Ed Leafe 9. 1 Tracy Pearson 10. 1 Rafael Copquin Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 SQLite 2. 12 This code doesn't work on this guy's new HP machine (but works on his own machine) -- both Win10 -- maybe a firewall issue? 3. 11 Bizarre scenario solved by READWRITE clause on end of SELECT SQL 4. 8 Greg Reichert / GLRsoftware.com 5. 8 Blast from the Past 6. 6 Bizarre scenario solved by READWRITE clause on end of SELECT SQL (SOLVED) 7. 6 images on labels 8. 6 [ADMIN] Problem uploading file to ProFox downloads section 9. 5 [NF] Forgotten password on Windows Server 2019 Hyper-V VM 10. 5 Networking Linux and Windows 11. 5 SetAll throws Variable Not Found 12. 4 Profox Archives 13. 4 AZURE and VFP 14. 3 [NF] Recommendations on a balance board for standup desk use 15. 3 NF Google maps update 16. 2 FoxPro Technical Consultant 17. 1 ProFox List Statistics for May 2020 18. 1 AW: Bizarre scenario solved by READWRITE clause on end of SELECT SQL 19. 1 AW: Greg Reichert / GLRsoftware.com 20. 1 This code doesn't work on this guy's new HP machine (but works on his own machine) -- both Win10 -- maybe a firewall issue? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 SQLite 2. 12 This code doesn't work on this guy's new HP machine (but works on his own machine) -- both Win10 -- maybe a firewall issue? 3. 11 Bizarre scenario solved by READWRITE clause on end of SELECT SQL 4. 8 Greg Reichert / GLRsoftware.com 5. 8 Blast from the Past 6. 6 Bizarre scenario solved by READWRITE clause on end of SELECT SQL (SOLVED) 7. 6 images on labels 8. 6 [ADMIN] Problem uploading file to ProFox downloads section 9. 5 [NF] Forgotten password on Windows Server 2019 Hyper-V VM 10. 5 Networking Linux and Windows 11. 5 SetAll throws Variable Not Found 12. 4 Profox Archives 13. 4 AZURE and VFP 14. 3 [NF] Recommendations on a balance board for standup desk use 15. 3 NF Google maps update 16. 2 FoxPro Technical Consultant 17. 1 ProFox List Statistics for May 2020 18. 1 AW: Bizarre scenario solved by READWRITE clause on end of SELECT SQL 19. 1 AW: Greg Reichert / GLRsoftware.com 20. 1 This code doesn't work on this guy's new HP machine (but works on his own machine) -- both Win10 -- maybe a firewall issue?

1 0

Networking Linux and Windows
by John Weller 30 Jun '20

30 Jun '20

I have a small home peer-to-peer network of 3 PCs running Win 10 over WiFi which works most of the time but seems to prefer it when the wind is from the East and there is an ‘R’ in the month 😊. At the start of lockdown I bought a Raspberry Pi which inspired me to install Ubuntu on a redundant laptop to learn Linux. Is there a simple way to include these in the network? Thanks John John Weller 01380 723235 07976 393631 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox