Page 1 of 2

FWH, VPN and SMB

Posted: Fri Apr 17, 2020 4:19 pm
by driessen
Hello,

A lot of my customers want to work from home due to the corona crisis.

Their IT-supplier installed a VPN, so they can make a connection from their PC or laptop at home to the server at the office.

If my applications are used, everything is going just fine, as long as only one user is running it.
If two or more user start working with my application, everything is starting to be very, very, very slow. And I'm talking about minutes, not seconds.

I have been told that SMB (1, 2 of 3) might be the problem.

If so, what can I do to make my application run much faster?

Thanks a lot in advance for any help.

Re: FWH, VPN and SMB

Posted: Fri Apr 17, 2020 4:59 pm
by Horizon
Database?

Re: FWH, VPN and SMB

Posted: Fri Apr 17, 2020 6:52 pm
by driessen
DBF-files with CDX RDD

Re: FWH, VPN and SMB

Posted: Fri Apr 17, 2020 7:01 pm
by Horizon
driessen wrote:DBF-files with CDX RDD
I am not expert as other friends, but I do not expect speed in dbf condition via internet. VPN is just a security.

I have the same problem like you. I have started to migrate my application MariaDB quickly. I expect more speed than dbf.

Re: FWH, VPN and SMB

Posted: Fri Apr 17, 2020 7:53 pm
by Antonio Mart.
My options:

1st. Terminal Server
2nd. LETODbf (not equal that LETODb)


Interesting: https://groups.google.com/forum/#!searc ... QDOekav30J

Re: FWH, VPN and SMB

Posted: Fri Apr 17, 2020 7:55 pm
by stefano
I also work in smart working and my modest program works very well

(home pc) vpn -> remote desktop office pc (executable) -> server (DBF archives)

Re: FWH, VPN and SMB

Posted: Fri Apr 17, 2020 9:03 pm
by driessen
I want to add some more information.

At the office of my customer, all user have a laptop, which they take home to work from home.
So there is no PC to connect to.
They run the executable from their laptop, using the database on the server through a VPN-connection.

Re: FWH, VPN and SMB

Posted: Sat Apr 18, 2020 11:09 am
by Horizon
Hi,

I think the fastest solution is remote desktop connection.

If you don't want to install it database server. You can reserve one w7 desktop in office and users can connect this computer. There is some hacks for more than one remote desktop connection in w7.

Re: FWH, VPN and SMB

Posted: Sat Apr 18, 2020 11:07 pm
by Marcelo Via Giglio
Hello,

to have a enviroment C/S the use of DBF is not the way, for this aproach is better to use some Database and SQL

Other solution is WinFlector

Saludos

Marcelo

Re: FWH, VPN and SMB

Posted: Sun Apr 19, 2020 10:26 pm
by Otto
Hello Michel,
Install remote desktop.
Create for every PC you have in the office a directory and clone the local dirs to the server.
Then create for every user a user account. This is the way to go.

Best regards,
Otto

Re: FWH, VPN and SMB

Posted: Sun Apr 19, 2020 10:42 pm
by driessen
Hello Otto,

Thanks a lot for your reply.
Problem is that there are no PC 's at the office right now.
At the office, all users have a laptop.
Since everyone is working from home, they take their laptop home.
So there is no PC at the office to install any form of remote desktop anymore.

Re: FWH, VPN and SMB

Posted: Mon Apr 20, 2020 6:21 am
by Marc Vanzegbroeck
Michel,

On which PC is the database then stored?

Re: FWH, VPN and SMB

Posted: Mon Apr 20, 2020 6:45 am
by driessen
Just a single Windows 10 PC.

Re: FWH, VPN and SMB

Posted: Mon Apr 20, 2020 6:59 am
by Marc Vanzegbroeck
Then you can install Windows Server on it, with enough CALs, so the customers can log in with RDP. Then you don't have to change anything in the program.

The best way of course is using SQL :D

Re: FWH, VPN and SMB

Posted: Mon Apr 20, 2020 8:48 am
by Otto
Why SQL - no advantages. Use a dedicated RDP server and the file system.
No layers in between. Why complicating if there are no advantages.