hi,
i saw Comments about SMB ...
many of these Comment are "outdate", while for SMB1, and not valid when using Windows 10 / 11
Note : it is NOT recommend to use "older" OS than Windows 10 any more
only some older
NAS will still use SMB1. change your
NAS ---
SMB1 should be DISABLE and SMB2 ENABLE which is default under Windows 10 / 11 !
to check it run Rowershell and type
- Code: Select all Expand view
Get-SmbServerConfiguration
now look for
EnableSMB1Protocol : False
EnableSMB2Protocol : True
---
are you using "Drive-Letter" or UNC-Path
when using "Drive-Letter" it work with LANmanager and UDP Port 135-139
have a look at Server / Network / Ports if there is Traffic on this Ports
if YES than you still working with OLD SMB1 and all it´s Problem
do NOT use OLD SMB1 "Hack" on Windows 10 / 11
---
since SMB2 we have a "Local Cache" which can made Problem when use "Local" Action
this is e.g. with "temporary" Action like INDEX ON or FERASE(localfile)
btw.
Question : does FiveWin "lock" Index like Xbase++ do
read here what is recommend for SMB2 when work with "temporary" Local Action
https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-7/ff686200(v=ws.10)?redirectedfrom=MSDNDISABLE under HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Lanman
Workstation\Parameters
- Code: Select all Expand view
FileInfoCacheLifetime
FileNotFoundCacheLifetime
DirectoryCacheLifetime
and set all 3 to 0 ( Zero ) on Workstation ( on Server only when using RDP )
---
General "File-Based" System will slow down when SMB switch from "Single Exclusive" to "Opportunistic lock".
Programmer like to "open" as much as possible and "leave" all "open" ...
that you can do with Single User App but it is not recommend in Network
under SQL you do not have "direct" Access to Data, Wifi can "lost Connection".
in older Network it was slow to open a DBF, read/write and close it. but that have change
very slow are TBrowse & Co which use a "Skipper" to navigate.
Spezial when using FILTER without SCOPE / Index it can very slow on big Database and make much Traffic
btw. same with SQL when not using LIMIT
so do use Resource only when need and avoid "Stand-by" of open Database when not need