Share via

Access database query performance when run over network share.

Anonymous
2011-01-28T14:35:34+00:00

I have an Access database performing the following tasks.

  1. Import a CSV file into a staging table
  2. Run an insert query that does some calculations and aggregates on this table inserting the query results into another table

When run locally, the import runs and the processing query completes in a timely manner.  However, when I try to run the same process with the database over a network share the process slows to nearly a stop.  The import process still runs in a timely manner and the problem seems to lie with the processing query.

I have also noticed that my cpu when running the database locally hovers around 15% but is much less when running the database over the network share.

I would appreciate any suggestions as to what the bottleneck might be and any possible ways to fix it.  Keeping the database on the network share would be ideal.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-01-28T15:54:41+00:00

    is this a DFS setup which would mean it might be burried even deeper or is this a straight forward share off of a server?

    I am in the process of finding this out.  There is another business unit that manages this and I am not sure.

    Can you post your Query's SQL?

    I am not able to post the sql.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-01-28T15:24:25+00:00

    share/directory/databasefolder - is this a DFS setup which would mean it might be burried even deeper or is this a straight forward share off of a server?

    Can you post your Query's SQL?

    Daniel Pineault, 2010 Microsoft MVP

    http://www.cardaconsultants.com

    MS Access Tips and Code Samples: http://www.devhut.net

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-01-28T15:01:47+00:00

    What is the path on your network (How deeply burried is your db)?

    The db is three levels deep  (share/directory/databasefolder)

    Has your db been split and each user is running their own copy of the front-end?

    There is only a single user.   I have tried splitting the database but the performance problem remains.

    What is your network speed (100Mbps, GigaBit)?  Is your network saturated by any chance?

    I am on a 100mbs lan.  I can copy large files to and from freely.

    The Server it is on, is it a very busy machine? It could be overused and simply slow at relaying the data.

    The server is not an overly busy machine.

    Anything else you can think of that might help us, help you.

    Nothing else other than that the import process runs fine over the network but the query does not.Thanks!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-01-28T14:53:38+00:00

    Networks can pose a problem, and troubleshooting can be hard, but let's gather some basic information and see what we can find out.

    What is the path on your network (How deeply burried is your db)?

    Has your db been split and each user is running their own copy of the front-end?

    What is your network speed (100Mbps, GigaBit)?  Is your network saturated by any chance?

    The Server it is on, is it a very busy machine? It could be overused and simply slow at relaying the data.

    Anything else you can think of that might help us, help you.

    Daniel Pineault, 2010 Microsoft MVP

    http://www.cardaconsultants.com

    MS Access Tips and Code Samples: http://www.devhut.net

    Was this answer helpful?

    0 comments