-
WAN deployment
I have a small database deployed on a WAN across country on the corporate network. Is the reason it is soooo slow is because I have an access front end and access back end? Will I get a noticeable improvement by rewriting the front end in VB.net with VS?
Thanks in advance.
-
Re: WAN deployment
Maybe, maybe not. Good luck.
-
Re: WAN deployment
The back end being a file-based database (which Access based databases are) will make it slower because the entire database needs to be transmitted over the network, your most likely speed boost is by changing the back end to a server-based database like SQL Server/Oracle/MySQL, which allows only the relevant records to be transmitted.
This is something that you can tested and implements fairly quickly, so it would be a good idea to do it before considering the front end.