Results 1 to 6 of 6
  1. #1
    Datech is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    40

    What to do when a split DB is slow?

    So I've secured corporate server space with domain authentication, successfully split the DB with a UNC path, and go to start it up for the first time.



    And it's really slow...

    For anyone who has seen any of my test DB's, my login screen takes 10 seconds to transition to the main menu. Any form that has queries or controls takes 30-90 seconds to fully populate on first use, and 10-20 seconds on all subsequent uses (return to main menu and open form again). The custom headcount code that we wrote that cycles through (currently) 175 records, compares them, and sets values in a field takes just under 10 minutes! Once you're on a page the queries and any updates or changes happen as fast as they should. Any form that doesn't have queries or controls is up immediately as well.

    So what's the deal?

    I don't know anything about the server. Is it processing power? Is it connection method (VPN client to corporate intranet)? Is it my queries? Is it the custom code?

    We've made a lot of changes since the last test DB, so I'll work on getting one up for dissection. In the mean time, is there any specific culprit to go after?

    Thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    My bet is on the VPN.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Datech is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    40
    Quote Originally Posted by June7 View Post
    My bet is on the VPN.
    Mine too

    I know that VPN's are usually custom, ugly beasts, but does anyone have any suggestions on what to ask my IT dept about it?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Review this thread and Albert Kallal link referenced http://discuss.joelonsoftware.com/de...el.3.406594.22

    Ooops, Albert's link not good.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Datech is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    40
    Quote Originally Posted by June7 View Post
    Review this thread and Albert Kallal link referenced http://discuss.joelonsoftware.com/de...el.3.406594.22

    Ooops, Albert's link not good.
    I read the whole discussion though. Since our DB is currently somewhat small (11 tables, max 500 records in one, average of ~75 records at the moment), would it be feasible for me to translate that to MSSQL Server in a small amount of time? I've never used it before, but I have access to it as well as some knowledgeable resources.

    If I moved to a SQL backend and continued to use the Access front end for the plethora of forms and reports we have (lots of fun and necessary ways to display our information), would that improve my performance over the VPN? The link you gave seems to hint at that, but I wanted to confirm.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I have no experience with VPN connection, only what I have heard. So I can't offer any confirmation or denial.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Slow Over Network
    By dnelson33 in forum Access
    Replies: 4
    Last Post: 02-07-2012, 10:34 AM
  2. Printing is slow
    By mikew in forum Access
    Replies: 2
    Last Post: 11-04-2011, 11:52 AM
  3. Replies: 4
    Last Post: 06-07-2011, 09:16 AM
  4. Slow Database
    By cadsvc in forum Database Design
    Replies: 3
    Last Post: 05-31-2011, 09:48 AM
  5. Slow Search
    By ggarza75 in forum Forms
    Replies: 1
    Last Post: 02-18-2011, 09:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums