Application slow over VPN

[xPaul]

All,

Quick question from me.

I have an Access application that is quite slow over VPN however when loading it or forms within it, it is quite slow. When searching for information within the forms - when entering a search term by the third character of said search term the search grinds to a halt.

The question that I have is that when copying the whole database from where it resides to the local computer via the VPN it is instantaneous.

Am I correct in thinking that this is simply because of a difference in protocols being used?

Thanks.

 

[Ranman256]

It depends. My VPN is fast sometimes.
Other days,it slows down.
PC speed, network speed, VPN connect speed,etc.

 

[Minty]

Unless you have a very quick and reliable VPN running access over it can be troublesome. You are dragging your data across the VPN network and if there is a lot of it the Access protocols expect a LAN connection type response.

If you can try using a remote desktop / citrix style app - much more reliable, and less likely to crash/corrupt etc.

 

[The_Doc_Man]

Depends, but VPN is usually fast or slow because of contention levels. The action of copying the file from point A to point B is a one-time copy whereas running FE/BE connections is a multiple transfer event. The difference is the window of opportunity for contention, and repeated transfers imply a "wider" window.

You asked about protocols. Since both sides of the connection use Windows File Sharing, both will ride the Server Message Block protocol, or SMB. So everything is the same whether copying the app or using it. The only way that you would use a different protocol would be to copy using FTP rather than drag-n-drop between your local system and a mapped drive.

 

[pbaldy]

Albert has some thoughts here, on top of those already given.

http://www.kallal.ca/wan/wans.html

 

[pbaldy]

2.5 year old thread?