-
Oct 5th, 2019, 06:02 PM
#1
Thread Starter
Member
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.
-
Oct 5th, 2019, 07:48 PM
#2
Re: WAN deployment
Maybe, maybe not. Good luck.
-
Oct 6th, 2019, 02:53 AM
#3
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|