Results 1 to 3 of 3

Thread: WAN deployment

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 2017
    Posts
    38

    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.

  2. #2
    Frenzied Member
    Join Date
    Nov 2017
    Posts
    1,561

    Re: WAN deployment

    Maybe, maybe not. Good luck.

  3. #3
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,659

    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
  •  



Click Here to Expand Forum to Full Width