hi Marc,
did you know LetoDb or NetIO for harbour 
it is still using DBF but it work over TCP/IP as Client/Server
so you get no SMB Problem and have no direct File Access.
greeting,
Jimmy
Jimmy
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour dbfntx very slow with 2+ users
Jimmy,
>> did you know LetoDb or NetIO for harbour
Where can I download some documentation?
Marco Boschi
info@marcoboschi.it
info@marcoboschi.it
Dear Otto,
thank for you invitation 
Marco Boschi
info@marcoboschi.it
info@marcoboschi.it
Jimmy wrote:hi Marc,
did you know LetoDb or NetIO for harbour
it is still using DBF but it work over TCP/IP as Client/Server
so you get no SMB Problem and have no direct File Access.
No, I will look for info about them.
I also have no idea about the SMB problem (no idea what SMB is (look into it)
I Also have a peer to peer 4 users. Put a SSD as harddrives and network cards of 1.000 mb
So, folowing all the tips that show up here...
Marc Venken
Using: FWH 23.08 with Harbour
Using: FWH 23.08 with Harbour
Marco,
I have used many systems also LetoDb.
These are all just workarounds.
There is a request to the server and then the data is transferred to the client.
It is different with RDP. Only the changed pixels of the screen are transferred.
You, and especially if you are a small company, should use RDP.
All your problems will disappear with it.
And another warning.
The young generation of business managers replaces all desktop programs with web applications.
The dangerous thing for us desktop program vendors is that we don't even get informed.
They look for a new program and then send you an email where they thank you for your years of cooperation and ask for your understanding.
Although mod harbour makes it relatively easy for us to change and update our programs, it is a lot of work in detail.
With RDP, you practically have similar behavior to web applications.
You can get used to the new way of thinking without much effort.
Best regards,
Otto
My mod harbour diary
https://mybergland.com/fwforum/kassabuch/kassabuchmenu.html
I have used many systems also LetoDb.
These are all just workarounds.
There is a request to the server and then the data is transferred to the client.
It is different with RDP. Only the changed pixels of the screen are transferred.
You, and especially if you are a small company, should use RDP.
All your problems will disappear with it.
And another warning.
The young generation of business managers replaces all desktop programs with web applications.
The dangerous thing for us desktop program vendors is that we don't even get informed.
They look for a new program and then send you an email where they thank you for your years of cooperation and ask for your understanding.
Although mod harbour makes it relatively easy for us to change and update our programs, it is a lot of work in detail.
With RDP, you practically have similar behavior to web applications.
You can get used to the new way of thinking without much effort.
Best regards,
Otto
My mod harbour diary
https://mybergland.com/fwforum/kassabuch/kassabuchmenu.html
hi Marc,
read here about Opportunistic locks (oplocks)
https://docs.microsoft.com/en-US/windows/win32/fileio/opportunistic-locks
this Paper is about : "What's New in SMB"
Applies To: Windows 7, Windows Server 2008 R2 (SMB-2)
https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ff625695(v=ws.10)?redirectedfrom=MSDN
---
SMB-2 also have a "Local Cache" which is used e.g. INDEX ON even when Index is on Server
so you need to "disable" it
?redirectedfrom=MSDN)
---
Speed depend on "Cache" and if "Cache" is invalid than you get Data Corruption ( most Index )
when only 1 User access File it will be no Problem with "Cache"
but when 2nd User access same File you need "to share Cache" too
---
most Problem i have in Network of Customer are Antivirus Apps
also Speed are "lost" while Antivirus App does "sniff" what is transfer
disable Antivirus from DATA Folder does Speed-up a lot ... but "Security" is lost
Marc Venken wrote:
I also have no idea about the SMB problem (no idea what SMB is (look into it)
read here about Opportunistic locks (oplocks)
https://docs.microsoft.com/en-US/windows/win32/fileio/opportunistic-locks
this Paper is about : "What's New in SMB"
Applies To: Windows 7, Windows Server 2008 R2 (SMB-2)
https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ff625695(v=ws.10)?redirectedfrom=MSDN
---
SMB-2 also have a "Local Cache" which is used e.g. INDEX ON even when Index is on Server
so you need to "disable" it
---
Speed depend on "Cache" and if "Cache" is invalid than you get Data Corruption ( most Index )
when only 1 User access File it will be no Problem with "Cache"
but when 2nd User access same File you need "to share Cache" too
---
most Problem i have in Network of Customer are Antivirus Apps
also Speed are "lost" while Antivirus App does "sniff" what is transfer
disable Antivirus from DATA Folder does Speed-up a lot ... but "Security" is lost
greeting,
Jimmy
Jimmy
hi Marco,
LetoDB https://www.kresin.ru/en/letodb.html
NetIO is Part of harbour Constribution
https://github.com/harbour/core/blob/master/contrib/hbnetio/utils/hbnetio/hbnetio.prg
to read
http://harbourlanguage.blogspot.com/2010/04/harbour-netio.html
MiniGUI Extended Version (use BCC) have Sample with Demo Source
http://hmgextended.com/files/CONTRIB/hmg-22.03-setup.exe
MarcoBoschi wrote:Where can I download some documentation?
LetoDB https://www.kresin.ru/en/letodb.html
NetIO is Part of harbour Constribution
https://github.com/harbour/core/blob/master/contrib/hbnetio/utils/hbnetio/hbnetio.prg
to read
http://harbourlanguage.blogspot.com/2010/04/harbour-netio.html
MiniGUI Extended Version (use BCC) have Sample with Demo Source
http://hmgextended.com/files/CONTRIB/hmg-22.03-setup.exe
greeting,
Jimmy
Jimmy
Otto,
when you say
> You, and especially if you are a small company, should use RDP.
> All your problems will disappear with it.
but license for 1 user costs about 150 euros
And the server the server must be sized appropriately I don't remember how much ram each user ...
In my opinion in a local area network if it were programmatically optimized the index management (DBFCDX)
maybe the file/server architecture is still the winning choice
each user uses the power of his own client pc
Security is perhaps the only problem.
In my opinion is in a local network if it were programmatically optimized index management (DBFCDX)
maybe the file/server architecture is still the winning choice
Each user uses the power of his own client pc and do not use the pc as a terminal in wich the only used program is mstc.exe
then deciding how important is security in a particular scenario is another matter
last but not least if I change my program that user use eyes wide shut they kill me
Marco Boschi
info@marcoboschi.it
info@marcoboschi.it
Marco,
>but license for 1 user costs about 150 euros
That's why I asked you if it was a hobby application or for professional use.
I am posting some screens here.
Please note that FIVEWIN programs need very little memory.
Outlook is the biggest consumer here.
But you don't have to use Outlook in the RDP session.
We do it because we have a document management included in
WINHOTEL and you can simply drag and drop emails into WINHOTEL.
Please understand that all the clients use the full power the server has.
Also, if you access with a smartphone or a tablet, you have the speed of the server!
I wish you a happy Easter.
Best regards,
Otto
>but license for 1 user costs about 150 euros
That's why I asked you if it was a hobby application or for professional use.
I am posting some screens here.
Please note that FIVEWIN programs need very little memory.
Outlook is the biggest consumer here.
But you don't have to use Outlook in the RDP session.
We do it because we have a document management included in
WINHOTEL and you can simply drag and drop emails into WINHOTEL.
Please understand that all the clients use the full power the server has.
Also, if you access with a smartphone or a tablet, you have the speed of the server!
I wish you a happy Easter.
Best regards,
Otto
Hello friends,
I add 2 more photos to my post.
On the screenshot you can see the memory consumption of the APACHE server with mod harbour.
And then quite interesting the hardware.
Above is the SERVERBOOK we put in operation in 2013 and it was in use 24 hours 365 days a year without ever problems.
Since it was still an i5 and had WINDOWS SERVER 2012 installed, we have now commissioned a new i7 SERVERBOOK with WINDOWS 2019 Server - the small one below.
Here is also mod harbour installed and WINHOTEL Desktop accesses the same databases as WINHOTEL online.
The SERVERBOOK is a fully professional SERVER. Even a UPS is built in.
Best regards,
Otto
I add 2 more photos to my post.
On the screenshot you can see the memory consumption of the APACHE server with mod harbour.
And then quite interesting the hardware.
Above is the SERVERBOOK we put in operation in 2013 and it was in use 24 hours 365 days a year without ever problems.
Since it was still an i5 and had WINDOWS SERVER 2012 installed, we have now commissioned a new i7 SERVERBOOK with WINDOWS 2019 Server - the small one below.
Here is also mod harbour installed and WINHOTEL Desktop accesses the same databases as WINHOTEL online.
The SERVERBOOK is a fully professional SERVER. Even a UPS is built in.
Best regards,
Otto
Otto,
Please provide a link to "Serverbook", a web search for "serverbook" only turns up a paper notebook.
James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Hello James,
Glad you like the idea. SERVERBOOK is our trademark.
We use HP PRO book as hardware for years.
Meanwhile, we have some Powershell scripts to do then all settings software based.
Now also including mod harbour and APACHE.
Best regards,
Otto
PS: By the way, the website was created by Ruth with mod harbour.
https://winhotel.space/winhotel_webpage/megamenu.prg?page_id=1518
Glad you like the idea. SERVERBOOK is our trademark.
We use HP PRO book as hardware for years.
Meanwhile, we have some Powershell scripts to do then all settings software based.
Now also including mod harbour and APACHE.
Best regards,
Otto
PS: By the way, the website was created by Ruth with mod harbour.
https://winhotel.space/winhotel_webpage/megamenu.prg?page_id=1518