dbfntx very slow with 2+ users

[Jimmy]

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.

[MarcoBoschi]

Jimmy,
>> did you know LetoDb or NetIO for harbour
Where can I download some documentation?

[MarcoBoschi]

Dear Otto,
thank for you invitation

[Marc Venken]

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...

[Otto]

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

[Jimmy]

hi Marc,

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

[Jimmy]

hi Marco,

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

[MarcoBoschi]

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

[Otto]

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

[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

[James Bott]

Otto,

Please provide a link to "Serverbook", a web search for "serverbook" only turns up a paper notebook.

James

[Otto]

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