FWH, VPN and SMB

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

[Horizon]

Database?

[driessen]

DBF-files with CDX RDD

[Horizon]

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.

[Antonio Mart.]

My options:

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


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

[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)

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

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

[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

[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

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

[Marc Vanzegbroeck]

Michel,

On which PC is the database then stored?

[driessen]

Just a single Windows 10 PC.

[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

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